查询学生各科目成绩和平均成绩
SELECT
t.student_name,
g.course_name,
g.score,
avg_scores.avg_score AS average_score
FROM grades AS g
JOIN students AS t ON g.student_id = t.student_id
JOIN (
SELECT student_id, AVG(score) AS avg_score
FROM grades
GROUP BY student_id
) AS avg_scores ON t.student_id = avg_scores.student_id
GROUP BY t.student_name, g.course_name, g.score,avg_scores.avg_score;
Mysql练习题
最新推荐文章于 2024-10-09 10:32:38 发布