[SQL문제풀기] Top Ranked Songs

문제

StrataScratch - Top Ranked Songs

StrataScratch

https://platform.stratascratch.com/coding/9991-top-ranked-songs?code_type=3

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select trackname, count(distinct id) "number of times"
from spotify_worldwide_daily_song_ranking
where position = 1
group by trackname
order by 2 desc;