我在想想..
mysql> select * from student;
+-----+------+-------+-------+
| sid | name | calss | score |
+-----+------+-------+-------+
| 1 | 张三 | php班 | 57 |
| 2 | 李四 | asp班 | 59 |
| 3 | 王五 | net班 | 59 |
| 4 | 小倩 | asp班 | 58 |
| 5 | 小张 | php班 | 98 |
| 6 | 小陈 | net班 | 66 |
| 7 | 小李 | htm班 | 78 |
| 8 | 小王 | php班 | 45 |
+-----+------+-------+-------+


查询各个班不及格的学生与及格的学生

------解决方案--------------------

SQL code

select class,sum(if(score < 60,1,0)) as '不及格',sum(if(score >=60,1,0)) as '及格' from student group by class

------解决方案--------------------

select class,count(case when score>=60 then 1 else 0 end) ,count(case when score<60 then 1 else 0 end)
from student
group by class