Not being able to use windowed values (rank, lead lag etc) to filter in the base query, but the query engine is quite happy when you wrap the query in a WITH CTE AS (...) and then filter on windowed field when you SELECT * FROM CTE.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Not being able to use windowed values (rank, lead lag etc) to filter in the base query, but the query engine is quite happy when you wrap the query in a WITH CTE AS (...) and then filter on windowed field when you SELECT * FROM CTE.