SQL 查询：筛选发布视频平均时长大于300秒的 UP 主

SELECT video_id FROM ( SELECT uploader_id, AVG(video_duration) AS average_duration FROM uploader_video_record GROUP BY uploader_id HAVING average_duration > 300 ORDER BY average_duration DESC, video_id ASC LIMIT 5 OFFSET 2 ) AS subquery;