SQL语句按年龄段分组统计人数_MySQL

SQL语句按年龄段分组统计人数

Java代码

create table #t(Uname varchar(10),age int)

insert #t

select &＃39;啊啊&＃39;,19 union all

select &＃39;信息&＃39;,23 union all

select &＃39;宝宝&＃39;,31 union all

select &＃39;喔喔&＃39;,21 union all

select &＃39;米米&＃39;,6

select nnd as &＃39;年龄段&＃39;,count(*) as &＃39;人数&＃39; from(

select

case

when age>=1 and age<=10 then &＃39;1-10&＃39;

when age>=11 and age<=20 then &＃39;11-20&＃39;

when age>=21 and age<=30 then &＃39;21-30&＃39;

when age>=31 and age<=40 then &＃39;31-40&＃39;

end

as nnd,uname from #t

)a group by nnd