T615 LEAD and LAG functions

[TedCraft]

You have an error in your SQL syntax: SELECT CUST_CODE CUST_NAME rank() over (order by opening_amt) lead(opening_amt1) over (order by opening_amt) FROM CUSTOMER order by opening_amt no viable alternative at input '(' at line 1 position 42 near @942:42='('<29>1:42