题解 | 每个月Top3的周杰伦歌曲

select month ,ranking,song_name,play_pv
from (
    select  month(fdate) as month ,row_number() over (partition by  month( fdate) order by count(*) desc  ,play_log.song_id ) as ranking,song_name,count(*) as play_pv
    from play_log join song_info si on play_log.song_id = si.song_id
join user_info ui on play_log.user_id = ui.user_id
    where singer_name='周杰伦' and age>=18 and age<=25
     group by month(fdate), song_name,si.song_id

     ) as t1
where  ranking<=3