New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open

pigxx500kg opened this issue Aug 11, 2023 · 1 comment

pigxx500kg commented Aug 11, 2023

No description provided.

Author

pigxx500kg commented Aug 11, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment