KPIs per country
In chapter 1 you were asked to provide a report about the development of the company. This time you have to prepare a similar report with KPIs for each country separately. Your manager is interested in the total number of movie rentals, the average rating of all movies and the total revenue for each country since the beginning of 2019.
Latihan ini adalah bagian dari kursus
Data-Driven Decision Making in SQL
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
SELECT *
FROM ___ -- Augment the table renting with information about customers
LEFT JOIN ___
___
LEFT JOIN ___ -- Augment the table renting with information about movies
___
___; -- Select only records about rentals since the beginning of 2019