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.