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

select
    month,
    ranking,
    song_name,
    play_pv
from (
    select
        month(fdate) month,
        row_number() over(partition by month(fdate) order by count(p.song_id) desc, p.song_id) ranking,
        song_name,
        count(p.song_id) play_pv
    from
        play_log p 
    left join song_info s on p.song_id=s.song_id
    left join user_info u on p.user_id=u.user_id
    where age between 18 and 25 and year(fdate) = 2022 and singer_name='周杰伦'
    group by month(fdate), song_name, p.song_id
) sub
where ranking <= 3