3.查询所有同学的学号 姓名 选课数 总成绩

select a.sid,a.sname,count(b.cid),sum(b.score)from Student as aleft join SC as b on a.sid=b.sidgroup by sid,sname;

Student表：

sc表：

Teacher:

Course表：