Loading problem...
A music analytics platform stores ranking-list entries in a table and needs a frequency summary by artist.
Table: Spotify
Occurrence rule:
Task: Return one row per artist with:
Sorting rules:
Supported submission environments:
Spotify:
| id | track_name | artist |
|---------|--------------------|------------|
| 303651 | heart wont forget | sia |
| 1046089 | shape of you | ed sheeran |
| 33445 | im the one | dj khalid |
| 811266 | young dumb broke | dj khalid |
| 505727 | happier | ed sheeran |[
{"artist":"dj khalid","occurrences":2},
{"artist":"ed sheeran","occurrences":2},
{"artist":"sia","occurrences":1}
]Explanation
dj khalid and ed sheeran each appear twice, so the tie is resolved by artist name ascending. sia appears once.
Spotify:
| id | track_name | artist |
|----|----------------|----------|
| 1 | morning lights | aurora |
| 2 | sky pulse | aurora |
| 3 | afterburn | blaze |
| 4 | runway | comet |
| 5 | static noise | comet |
| 6 | deep horizon | comet |[
{"artist":"comet","occurrences":3},
{"artist":"aurora","occurrences":2},
{"artist":"blaze","occurrences":1}
]Explanation
comet has the highest count, followed by aurora, then blaze.
Spotify:
[][]Explanation
No rows means no artists to report.
Constraints