Get startedGet started for free

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

View Course

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
Edit and Run Code