SQL 查询：筛选视频时长大于 300 秒的 UP 主并排序

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;