mysql 年龄段划分

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

insert #t  

select '啊啊',19 union all   

select '信息',23 union all    

select '宝宝',31 union all    

select '喔喔',21 union all    

select '米米',6   

select nnd as '年龄段',count(*) as '人数' from(  

 select   

 case  

  when age>=1 and age<=10 then '1-10'  

  when age>=11 and age<=20 then '11-20'  

  when age>=21 and age<=30 then '21-30'  

  when age>=31 and age<=40 then '31-40'   

 end   

 as nnd,uname from #t  

)a group by nnd