【SQL】根据年龄段排序

首先创建一个表，并添加数据

然后执行sql

select length as 年龄段,count(length) as 人数 from (
select age,
case
when age between 1 and 10 then '1-10'
when age between 11 and 20 then '11-20'
when age between 21 and 30 then '21-30'
when age > 30 then '30>'
end as length
from test2
) as A group by length;