题目描述:
现有表stu_score ,有字段 id, cid, score .分别代表 学生id,课程id,分数。
要求:用一条SQL语句查询出每门课程的及格人数和不及格人数。
select cid,
sum(case when score>=60 then 1 else 0 end) as 及格人数,
sum(case when score<60 then 1 else 0 end) as 不及格人数
from stu_score
group by cid
结果: