用一条SQL语句查询出每个班的及格人数和不及格人数,格式为:class,及格人数,不及格人数(score>=60为及格)
selet class 班级
sum(case when score >60 then 1 else 0 end) as 及格人数,
sum(case when socre <60 then 1 else 0 end) as 不及格人数
from score GROUP BY class;
更多干货关注:
用一条SQL语句查询出每个班的及格人数和不及格人数,格式为:class,及格人数,不及格人数(score>=60为及格)
selet class 班级
sum(case when score >60 then 1 else 0 end) as 及格人数,
sum(case when socre <60 then 1 else 0 end) as 不及格人数
from score GROUP BY class;
更多干货关注: