1.查分数大于90的学生,小于60的学生
方法1(or null 不可去掉)
select count(score>90 or null),count(score < 60 or null)
from scores;
方法2
select count(case when score>90 then score end),count(case when score<60 then score end)
from scores;
引自https://blog.csdn.net/acceptedemmm/article/details/80114553