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.
This exercise is part of the course
Data-Driven Decision Making in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
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