select month ,rn as ranking ,song_name ,play_pv from( select month(fdate) as month ,a.song_id as song_id ,b.song_name as song_name ,count(1) as play_pv ,row_number() over(partition by month(fdate) order by count(a.song_id) desc,b.song_id) as rn from play_log a left join song_info b on a.song_id = ...