SELECT * FROM (SELECT month, ROW_NUMBER() OVER (PARTITION BY month ORDER BY play_pv DESC ,song_id) AS ranking, song_name, play_pv FROM (SELECT MONTH(fdate) AS month, MIN(p.song_id) AS song_id, COUNT(1) AS play_pv, MIN(song_name) AS song_name FROM play_log p JOIN user_info u ON p.user_id = u.user_id ...
