查询某个班级及格与不及格人数

select class 班级,

sum(case when score>=60 then 1 else 0 end) as 及格人数,
                  sum(case when score<60 then 1 else 0 end) as 不及格人数
        from tb1
        group by class;