1. Learn
    2. /
  2. Courses
    3. /
  3. Data-Driven Decision Making in SQL

Exercise

Ratings of movie 25

The movie ratings give us insight into the preferences of our customers. Report summary statistics, such as the minimum, maximum, average, and count, of ratings for the movie with ID 25.

Instructions

100 XP
  • Select all movie rentals of the movie with movie_id 25 from the table renting.
  • For those records, calculate the minimum, maximum and average rating and count the number of ratings for this movie.