求助：如何进行分段统计

[parade78]

如何按学生成绩（stu.score）进行分段统计，比如按60分以下、60－80、80分以上几段。最好一条语句的。谢谢先了

[CrazyFor]

select (case
when score<60 then '不及格'
when score<80 and score>60 then 'XX'
when score>80 then 'YYYYY'
end)

是这个意思吗？

[parade78]

是统计总数

[CrazyFor]

select (case
when score<60 then '不及格'
when score<80 and score>60 then 'XX'
when score>80 then 'YYYYY'
end)


select
sum(case when score<60 then 1 else 0 end) as 不及格数，
sum(case when ....................

[CrazyFor]

select
sum(case when score<60 then 1 else 0 end) as 不及格数，
sum(case when ....................

[yujohny]

select (case
when score<60 then COUNT(score) AS 不及格人数
when score<80 and score>=60 then COUNT(score) AS 及格人数
when score>80 then COUNT(score) AS 优秀人数
end) FROM 表1

[parade78]

ok，谢谢两位