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.
Latihan ini adalah bagian dari kursus
Data-Driven Decision Making in SQL
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Join the tables
SELECT *
FROM renting AS r
___ movies AS m
ON ___
___ customers AS c
ON ___;