MySQL統計,做個筆記
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
---score為分數,class為班級
轉載地址:https://blog.csdn.net/qq_34512307/article/details/73549321?utm_source=blogxgwz6