请在UP主视频数据表中筛选发布视频平均时长大于300秒的UP主按UP主视频平均时长倒序视频ID升序返回第3行到6行的视频ID。建表语句为CREATE TABLE uploader_video_recordvideo id BIGINT PRIMARY KEY uploader_id BIGINT video_duration int;
SELECT video_id FROM ( SELECT uploader_id, AVG(video_duration) AS avg_duration FROM uploader_video_record GROUP BY uploader_id HAVING avg_duration > 300 ORDER BY avg_duration DESC, video_id ASC LIMIT 5 OFFSET 2 ) AS subquery;
原文地址: https://www.cveoy.top/t/topic/iShJ 著作权归作者所有。请勿转载和采集!