Sales of Genres in Cities
Tarefa
Swipe to start coding
Which genre gives the biggest income in each city? To solve it:
- Calculate the total sales for each genre in each city: group records by city and genre.
- Order the records by city lexicographically and then by total sales, starting with most selling genre.
Output data under columns city
, genre
, and sales
.
Solução
Tudo estava claro?
Obrigado pelo seu feedback!
Seção 2. Capítulo 6