OK

got that sorted...the over clause shouldnt have a comma after the partition statement

next some issues with parenthesis

the final & correct sql statement was....

SELECT ...