Challenge 5: Multiple Aggregations (Difficult)
In this challenge, you will apply multiple aggregation functions to the same grouping of data.
We'll cover the following...
Problem definition
Your music analyst is interested in knowing multiple statistics at once, grouped by country
.These are as follows:
- Sum of plays
- Average of plays
- Maximum fans from all artists in the country