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