select Student.Sno,Sum(Ccredit) SumCredit
from Student--从学生表中查询学号、总学分
left join SC on SC.Sno=Student.Sno--通过学号左连接选修表
left join Course on Course.Cno=SC.Cno--通过课程号左连接课程表
Group by Sname,Student.Sno--通过姓名、学号分组
having Sum(Ccredit)>8;--选择总学分大于8的
select Student.Sno,Sum(Ccredit) SumCredit
from Student--从学生表中查询学号、总学分
left join SC on SC.Sno=Student.Sno--通过学号左连接选修表
left join Course on Course.Cno=SC.Cno--通过课程号左连接课程表
Group by Sname,Student.Sno--通过姓名、学号分组
having Sum(Ccredit)>8;--选择总学分大于8的