mysql 按照年龄段分组查询

1.mysql 按照年龄段分组查询

 SELECT
CASE
    
WHEN
    a.age >= 11 
    AND a.age <= 20 THEN '11-20' WHEN age >= 21 
    AND a.age <= 30 THEN
    '21-30' ELSE '20-100' 
    END AS nld,
    count( * ) 
FROM
    (
SELECT
    round( TIMESTAMPDIFF( MONTH, date( gmt_create ), date( NOW( ) ) ) / 12 ) AS age 
FROM
    edu_teacher 
    ) a 
GROUP BY
    nld