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!
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.