liyupi / sql-mother

免费的闯关式 SQL 自学教程网站,从 0 到 1 带大家掌握常用 SQL 语法,纯前端实现,简单易学~
http://sqlmother.yupi.icu
3.34k stars 367 forks source link

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

Open pigxx500kg opened 1 year ago

pigxx500kg commented 1 year ago

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