Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Evaluation Order and Common Problems
Window functions and GROUP BY
Summary and Review


The same problem occurs when we try to use a window function in the HAVING clause.


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.