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.
Deze oefening maakt deel uit van de cursus
Data-Driven Decision Making in SQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Join the tables
SELECT *
FROM renting AS r
___ movies AS m
ON ___
___ customers AS c
ON ___;