题解 | 输出播放量最高的视频
输出播放量最高的视频
https://www.nowcoder.com/practice/9e9cb264e1f64e28846975d5a32ba8e4
with t1 as( select a.id,a.cid,sum(if(a.start_time between b.start_time and b.end_time,1,0)) as cnt from play_record_tb a join play_record_tb b on a.cid=b.cid group by a.id,a.cid) select cid,max(cnt) as max_play_count from t1 group by cid order by max_play_count desc,cid asc limit 3
参考评论区的答案。记录a只要在b的播放时间内就算一条记录。
