count-artist-occurrences-on-spotify-ranking-list.sql

# Time:  O(nlogn)
# Space: O(n)

SELECT
    artist,
    count(1) AS occurrences
FROM Spotify
GROUP BY artist
ORDER BY occurrences DESC, artist ASC;