liyupi/sql-mother

关卡26 应该说明最后结果的列中不含class_id列吧

pigxx500kg opened this issue · 1 comments

pigxx500kg commented
关卡26 应该说明最后结果的列中不含class_id列吧
pigxx500kg commented

SELECT *, AVG(score) OVER (PARTITION BY class_id) AS class_avg_score FROM student;
语句错误，因为题目描述中遗漏了 exam_num 这一列，答案中也没有包含

  • 👍1