1. Learn
    2. /
  2. Courses
    3. /
  3. Data-Driven Decision Making in SQL

Exercise

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.

Instructions 1/2

undefined XP
    1
    2
  • Augment the table renting with information about customers and movies.
  • Use as alias the first latter of the table name.
  • Select only records about rentals since beginning of 2019.