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

SELECT video_id\nFROM (\n SELECT video_id, AVG(video_duration) AS avg_duration\n FROM uploader_video_record\n GROUP BY uploader_id\n HAVING avg_duration > 300\n ORDER BY avg_duration DESC, video_id ASC\n) AS subquery\nLIMIT 3, 4;