Hi, i want to calculate the rank and i have the error as you see in the screenshot.
Thank you
‘turnover’ in your window function will refer to the raw column not your derived calculation (like PostgreSQL). You need to use either CTE or sub-SELECT
2 Likes