Challenge 5: Multiple Aggregations (Difficult)

In this challenge, you will apply multiple aggregation functions to the same grouping of data.

Problem definition

Your music analyst is interested in knowing multiple statistics at once, grouped by country.These are as follows:

  1. Sum of plays
  2. Average of plays
  3. Maximum fans from all artists in the country

Create a free account to view this lesson.

By signing up, you agree to Educative's Terms of Service and Privacy Policy