Exercise

Movies and ratings with correlated queries

Report a list of movies that received the most attention on the movie platform, (i.e. report all movies with more than 5 ratings and all movies with an average rating higher than 8).

Instructions 1/2

undefined XP
  • 1

    Select all movies with more than 5 ratings. Use the first letter of the table as an alias.

  • 2

    Select all movies with an average rating higher than 8.