1枚の表で,学生の合格者と不合格者の数を調べる

    :
---------------------
class    name    score
                 

       ,             
SELECT  `class`,
        SUM(CASE WHEN score>=60 THEN 1 ELSE 0 END) as gt60,
        SUM(CASE WHEN score>=60 THEN 0 ELSE 1 END) as lt60
FROM tb1
GROUP BY class

SELECT  class,
        SUM( IF(score >= 60, 1, 0) ) as gt,
        SUM( IF(score < 60, 1, 0 ) ) as lt
FROM tb1
GROUP BY class;