Analyzing preferences of genres across countries
You are asked to study the preferences of genres across countries. Are there particular genres which are more popular in specific countries? Evaluate the preferences of customers by averaging their ratings and counting the number of movies rented from each genre.
Questo esercizio fa parte del corso
Data-Driven Decision Making in SQL
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Join the tables
SELECT *
FROM renting AS r
___ movies AS m
ON ___
___ customers AS c
ON ___;