第一道sql题参考答案 SELECT userid, COUNT(DISTINCT video_id) AS video_count FROM watch_records WHERE start_time >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) -- 按开始时间筛选最近7天 GROUP BY userid HAVING video_count > 0 ORDER BY video_count DESC LIMIT 5;