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

select month,ranking,song_name,play_pv
from (select month,song_name,play_pv,row_number() over(partition by month order by play_pv desc,song_id) ranking
			from (select month(fdate) month, song_name,count(song_name) play_pv,PI.song_id
						from play_log PI
						inner join song_info SI 
							on PI.song_id = SI.song_id
						inner join user_info UI
							on PI.user_id = UI.user_id
						where age between 18 and 25 and year(fdate) = 2022 and singer_name = '周杰伦'
						group by month,song_name,PI.song_id
						order by month,play_pv desc) temp) temp0
where ranking <= 3