题解 | 被重复观看次数最多的3个视频
被重复观看次数最多的3个视频
https://www.nowcoder.com/practice/b75fa2412659422c96369976ee1f9504
with a as(
select
cid,
count(*) as numbers
from play_record_tb
group by cid,uid
having count(*)>=2
),
b as(
select
a.cid,
sum(numbers) as pv,
row_number() over(order by sum(numbers) desc,release_date desc) as rk
from a join course_info_tb using(cid)
group by a.cid,release_date
)
select
cid,
pv*1.000 as pv,
rk
from b
where rk<=3
order by rk;
查看15道真题和解析