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

select c.cid,
format(count(p.id),3) pv,
row_number()over(order by format(count(p.id),3) desc,release_date desc) rk
from course_info_tb c join play_record_tb p on c.cid = p.cid 
group by uid,p.cid,release_date
having pv>1
limit 3