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.

Bu egzersiz

Data-Driven Decision Making in SQL

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

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.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT ___ min_rating, -- Calculate the minimum rating and use alias min_rating
	   ___ max_rating, -- Calculate the maximum rating and use alias max_rating
	   ___ avg_rating, -- Calculate the average rating and use alias avg_rating
	   ___ number_ratings -- Count the number of ratings and use alias number_ratings
FROM renting
___; -- Select all records of the movie with ID 25

Kodu Düzenle ve Çalıştır