Mysql练习题

查询学生各科目成绩和平均成绩
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;