'Why am I getting a syntax Error on hackerrank SQL problem using window functions (partition by)

Hi I am trying to figure out why hackerrank is returning a syntax error on my query ran on their platform but when I run the same query I get no issues on mysql workbench.

Here is a snippet of the larger query I have written. I get an error 1064 (42000):

select  
lag(submission_date, 1,'2016-03-01') OVER(Partition by hacker_Id order by submission_date) 
from submissions ;
mysqlsyntax-errorwindow-functions


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions