试题题干
在数据库db_xuanke中，要为教务管理人员提供统计每个学生选修课程总学分的报表，请用 SQL 语句实现。
参考答案
试题解析
mysql> CREATE VIEW v_score(StuNo, totlescore)
- > AS
->SELECT student.StuNo, SUM(course.Credit)
->FROM student JOIN electing ON student.StuNo=electing.StuNo
->JOIN course ON course.CourseNo=electing.CourseNo
->WHERE electing.Score>=60
->GROUP BY student.StuNo;