Session Ready
Exercise

Average movie ratings

For each movie the average rating, the number of ratings and the number of views has to be reported. Generate a table with meaningful column names.

Instructions 1/4
undefined XP
  • 1
  • 2
  • 3
  • 4
  • Group the data in the table renting by movie_id and report the ID and the average rating.