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

select * from 
(select 
c.month,
row_number() over ( partition by c.month order by c.play_pv DESC) as ranking,
d.song_name,
c.play_pv
from (
select MONTH(a.fdate) as month , a.song_id,count(*) as play_pv 
from play_log as a
left outer join  user_info as b
on a.user_id=b.user_id	
where b.age between 18 and 25 
group by  MONTH(a.fdate),a.song_id) as c
left outer join song_info as d
on c.song_id=d.song_id
where d.singer_name = '周杰伦'
) as ranked 
where ranked.ranking <=3