题解 | 被重复观看次数最多的3个视频
被重复观看次数最多的3个视频
https://www.nowcoder.com/practice/b75fa2412659422c96369976ee1f9504
with t as (select p.uid, p.cid, count(*) as pv, c.release_date from play_record_tb p left join course_info_tb c on p.cid = c.cid group by uid, cid, c.release_date having count(*) > 1), t2 as (select cid, pv, row_number() over (order by pv desc, release_date desc ) as rk from t) select t2.cid, format(t2.pv,3), t2.rk from t2 limit 3
查看18道真题和解析
