排名先后由两者的song_id先后顺序决定

这个条件实现不了，求大佬解答：

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,                     song_name,                     count(*) as play_pv                 from                     (                         select                             *                         from                             play_log                             join song_info using (song_id)                             join user_info using (user_id)                         where                             age between 18 and 25                             and singer_name like '周杰伦'                         order by                             song_id                     ) as a                 group by                     month (fdate),                     song_name             ) as b     ) as c where     ranking <= 3