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

CREATE VIEW v_student_result_sum AS SELECT s.student_id, s.student_name, SUM(sc.score) AS total_score FROM student s INNER JOIN score sc ON s.student_id = sc.student_id GROUP BY s.student_id;