SQL statement grouping by age group count _ MySQL

The SQL statement counts the number of people by age group. bitsCN.com

Number of SQL statements grouped by age group

Java code

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

Insert # t

Select 'ah', 19 union all

Select 'info', 23 union all

Select 'baby', 31 union all

Select 'random Wo', 21 union all

Select 'mimeters ', 6

Select nnd as 'age group', count (*) as 'number of people' 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

BitsCN.com