查有成绩的学生信息
查有成绩的学生信息
发布时间：2026-01-25 11:36:03
请在 下方输入 要搜索的题目：
推荐参考答案 (
由 题搜搜 官方老师解答 )
答案：select s.Sid,S.Sname,count(score),sum(score), sum(case when SC.Cid=01 then score else null end) as score_1, sum(case when SC.Cid=02 then score else null end) as score_2, sum(case when SC.Cid=03 then score else null end) as score_3 from Student as s,SC,Course where s.Sid = SC.Sid and SC.Cid = Course.
