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

Introduction
Simple OVER()
PARTITION BY
Ranking functions
Window Frames
Analytic Functions
PARTITION BY ORDER BY
28. PARTITION BY ORDER BY – Exercise 3
Order of Evaluation
Finished!

Instruction

Impressive! Okay, this is going to be the very last exercise in this section.

Exercise

For each movie, show the following information: Title, Genre, the average user rating for that Movie (column AvgRating) and the movie's Rank within its Genre, based on that average rating. Use descending order so that the highest-ranked movies will be shown first.

Stuck? Here's a hint!

GROUP BY the movie Title and Genre, In the window function, partition by Genre, and order by the average rating.