Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions in MS SQL Server

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

Instruction

Just as we expected, no window functions are allowed in HAVING. Okay, you know that the remedy is to use a subquery. Try to correct the query on your own. Don't worry if you can't; the hint is there if you need it.

Exercise

Show the country name and average final auction price for countries that have higher than average final price. Correct the query by using a subquery.

Stuck? Here's a hint!

Instead of AVG(FinalPrice) OVER() at the end, put a small subquery in there. You don't even need a window function; simply calculate the average from all rows.