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.
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.
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