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

select * from 
(
	select 
		month(p.fdate) `month`,
		row_number() over(partition by month(p.fdate) order by count(p.user_id) desc, min(p.song_id)) ranking,
		s.song_name song_name,
		count(p.user_id) play_pv
	from play_log p 
	inner join song_info s 
	on p.song_id = s.song_id and s.singer_name  ='周杰伦' 
	inner join user_info u on u.user_id = p.user_id and u.age between 18 and 24
	group by month(p.fdate ),s.song_name
	order by month(p.fdate),s.song_name

) t
where ranking <= 3

order by `month`,ranking