查询所有同学的学号、姓名、选课数、总成绩；
时间:2019-01-05 22:20 来源:未知 作者:IT
select Student.S#,Student.Sname,count(SC.C#),sum(score)
from Student left Outer join SC on Student.S#=SC.S#
group by Student.S#,Sname (责任编辑：IT)
| select Student.S#,Student.Sname,count(SC.C#),sum(score) from Student left Outer join SC on Student.S#=SC.S# group by Student.S#,Sname (责任编辑：IT) |