题解 | 输出播放量最高的视频
输出播放量最高的视频
https://www.nowcoder.com/practice/9e9cb264e1f64e28846975d5a32ba8e4
SELECT DISTINCT
cid,
MAX(uv) max_peak_uv
FROM
(SELECT
t1.cid,
SUM(if(t1.start_time BETWEEN t2.start_time AND t2.end_time ,1,0)) uv
FROM play_record_tb t1
JOIN play_record_tb t2 ON t1.cid = t2.cid
WHERE TIMEDIFF(t1.end_time, t1.start_time) >= 0
GROUP BY t1.id) t3
GROUP BY cid
ORDER BY max_peak_uv DESC, cid
LIMIT 3
深信服公司福利 827人发布