题解 | 被重复观看次数最多的3个视频

select cid, pv, row_number() over (order by pv desc, release_date desc) as rk
from (
    select a.cid, cast(count(1) as float) as pv, release_date
    from play_record_tb a join course_info_tb b on a.cid=b.cid
    group by uid, cid, release_date
    having pv>1
) temp
order by rk
limit 3