题解 | 输出播放量最高的视频
输出播放量最高的视频
https://www.nowcoder.com/practice/9e9cb264e1f64e28846975d5a32ba8e4
关键：理解题意，通过自连接计算每个时间段（start_time）的播放量。
select cid,round(max(cnt)*1.0,3) max_peak_uv from ( select t1.id,t1.cid ,sum(if(t1.start_time between t2.start_time and t2.end_time,1,0)) cnt from play_record_tb t1 join play_record_tb t2 on t1.cid=t2.cid group by t1.id,t1.cid,t1.start_time ) t group by cid order by max_peak_uv desc limit 3
OPPO公司福利 1077人发布