Evaluation Order and Common Problems
Window functions and GROUP BY
Summary and Review

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 I'm done. Next exercise to continue.