Session Ready
Exercise

Exploring rating by country and gender

Now you will investigate the average rating of customers aggregated by country and gender.

Instructions 1/4
undefined XP
  • 1

    Select the columns country, gender, and rating and use the correct join to combine the table renting with customer.

    • 2

      Use GROUP BY to calculate the average rating over country and gender. Order the table by country and gender.

    • 3

      Now, use GROUPING SETS to get the same result, i.e. the average rating over country and gender.

    • 4

      Report all information that is included in a pivot table for country and gender in one SQL table.