题解 | 被重复观看次数最多的3个视频
被重复观看次数最多的3个视频
https://www.nowcoder.com/practice/b75fa2412659422c96369976ee1f9504
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
查看8道真题和解析