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.
Bu egzersiz
Data-Driven Decision Making in SQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
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