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

select 
tb.c_id as cid,sum(cnt) as pv,
row_number()over(order by sum(cnt) desc,tb.rd desc) as rk
from
(select p.uid as user_id,c.cid as c_id,format(count(c.id),3) as cnt,c.release_date as rd
from play_record_tb p
join course_info_tb c
on c.cid=p.cid
group by p.uid,c.cid,c.release_date ) tb
where cnt>1
group by tb.c_id,tb.rd
order by rk
limit 3;