mysql 按照年龄段分组查询

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `city` varchar(40) NOT NULL,
  `age` int(11) DEFAULT NULL
) ;

按照年龄段查询人数：

SELECT
    nld AS '年龄段',
    count(*) AS '人数'
FROM
    (
        SELECT
            CASE

        WHEN age >= 11
        AND age <= 20 THEN
            '11-20'
        WHEN age >= 21
        AND age <= 30 THEN
            '21-30'

        END AS nld
        FROM
            student
    ) a
GROUP BY
    nld

查询结果：