Analyzing average ratings
Prepare a table for a report about the national preferences of the customers from MovieNow comparing the average rating of movies across countries and genres.
This exercise is part of the course
Data-Driven Decision Making in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Augment the records of movie rentals with information about movies and customers
SELECT *
FROM ___
LEFT JOIN ___
ON ___
LEFT JOIN ___
ON ___;