Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Simple OVER()
PARTITION BY
12. PARTITION BY – Exercise 2
Ranking functions
Window frame
Analytic functions
ORDER BY PARTITION BY
Order of evaluation
Summary

## Instruction

That's true, of course. Let's move on to more difficult examples!

## Exercise

For each distinctive movie, show the title, the average customer rating for that movie (as the avg_movie_rating column), the average customer rating for the entire genre (as the avg_genre_rating column), and the average customer rating for all movies (as the avg_rating column).

### Stuck? Here's a hint!

Here, join two tables: review and movie. You will need to partition by the movie_id and by genre.