單項選擇題
查詢所有同學(xué)的學(xué)生編號、學(xué)生姓名、選課總數(shù)、所有課程的總成績(沒成績的顯示為null) select student.sid, student.sname, t1.coursecount, t1.sumscore from student inner join ( select sc.sid, count(sc.cid) as coursecount, sum(sc.score) as sumscore from sc group by sc.sid) as t1 on student.sid = t1.sid
A.sid,
B.sname,
C.coursecount,
D.sumscore
E.sid,
F.cid)
G.score)
H.sid)
I.sid
J.sid