7,713
社区成员
发帖
与我相关
我的任务
分享
select
sum(iif(成绩 between 0 and 59,1,0)) ,
sum(iif(成绩 between 60 and 69,1,0)) ,
sum(iif(成绩 between 70 and 79,1,0)) ,
sum(iif(成绩 between 80 and 100,1,0))
from tt
select
sum(case when 成绩 < 60 then 1 else 0 end) [60以下],
sum(case when 成绩 < 70 and 成绩 >= 60 then 1 else 0 end) [60-70],
sum(case when 成绩 < 80 and 成绩 >= 70 then 1 else 0 end) [70-80],
sum(case when 成绩 >= 80 then 1 else 0 end) [80以上]
from tb