Evaluation Order and Common Problems
Window functions and GROUP BY
Instruction
The same problem occurs when we try to use a window function in the HAVING clause.
Exercise
This time, find out for yourself that window functions don't work in the HAVING clause. Look at the template: we would like to show the countries with a higher-than-average final price (compared to all countries). Try to run this query.
When you're done, click to continue.
