Probable cause

A window function was used in the WHERE or HAVING clause of a SELECT statement. Consider making the SELECT into a derived table, putting the window function in the select list of the derived table, and changing the predicate to reference the derived column.