SELECT `class`, SUM(CASE WHEN score>=60 THEN 1 ELSE 0 END), SUM(CASE WHEN score>=60 THEN 0 ELSE 1 END) FROM tb1 GROUP BY 1
主è¦æ¯èè¯GROUP BYåç»ç»è®¡ï¼CASE WHEN THEN ELSE ENDåæ å½¢åè½ï¼è¿ä¸ªæ¯éå¸¸å ¸åçåºç¨ï¼å ä¹ææçæ°æ®åºé½æ¯æä¸é¢çè¯å¥ã
select class,及格人数,不及格人数 from (select class,count(*) 及格人数 from tb1 where score>=60 group by class) t1 join (select class, count(*) 不及格人数 from tb1 where score<60 group by class) t2 on t1.class=t2.class;