统计个分数段人数
统计个分数段的人数sql
1.
select
sum(case when 分数 >=40 and 分数 <60 then 1 else 0 end) as '40-59',
sum(case when 分数 >=60 and 分数 <85 then 1 else 0 end) as '60-84',
sum(case when 分数 >=85 then 1 else 0 end) as '85-'
from 分数表
2.
select 分数段, 人数=count(*)from
(
select 分数, 分数段=case
when 分数= 0 then'0'
when 分数 between 0 and 9 then'1~9'
when 分数 between 10 and 19 then'10~19'
when 分数 between 20 and 29 then'20~29'
when 分数 between 30 and 39 then'30~39'
when 分数 between 40 and 49 then'40~49'
when 分数 between 50 and 59 then'50~59'
when 分数 between 60 and 69 then'60~69'
when 分数 between 70 and 79 then'70~79'
when 分数 between 80 and 89 then'80~89'
when 分数 between 90 and 99 then'90~99'
when 分数= 100 then'100'
end
from tb
) t
group by 分数段