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.