表结构: Student(S#,Sname,Sage,Ssex) 学生表 、Course(C#,Cname,T#) 课程表 、SC(S#,C#,score) 成绩表 、Teacher(T#,Tname) 教师表 , 查询所有同学的、姓名、选课数、总成绩
A.
select student.s#,student.sname,count(sc.c#)as 选课数,sum(score)总成绩 from student,sc where student.s#=sc.s# group by student.s#,student.sname
B.
select student.s#,student.sname,count(sc.c#)as 选课数,sum(score)总成绩 from student inner join sc on student.s#=sc.s# group by student.s#,student.sname
C.
select student.s#,student.sname,count(sc.c#)as 选课数,sum(score)总成绩 from student inner join sc where student.s#=sc.s# group by student.s#,student.sname
D.
select student.s#,count(sc.c#)as 选课数,sum(score)总成绩 from student inner join sc where student.s#=sc.s# group by student.s#