mysql创建视图v_student_result_sum统计每位同学所有课程的总分显示学号、姓名和总分列。

CREATE VIEW v_student_result_sum AS SELECT s.id AS 学号, s.name AS 姓名, SUM(c.score) AS 总分 FROM student s JOIN course_result c ON s.id=c.student_id GROUP BY s.id, s.name;