[SQL문제풀기] Artist Appearance Count

문제

StrataScratch - Artist Appearance Count

StrataScratch

https://platform.stratascratch.com/coding/9992-find-artists-that-have-been-on-spotify-the-most-number-of-times?code_type=3

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select artist, count(distinct id) "number of appearances"
from spotify_worldwide_daily_song_ranking
group by artist
order by 2 desc;