mysql年龄分段统计表

SELECT 
    CASE 
        WHEN age BETWEEN 0 AND 5 THEN '0-5'
        WHEN age BETWEEN 6 AND 12 THEN '6-12'
        WHEN age BETWEEN 13 AND 19 THEN '13-19'
        WHEN age BETWEEN 20 AND 39 THEN '20-39'
        WHEN age BETWEEN 40 AND 59 THEN '40-59'
        ELSE '60+'
    END AS age_group,
    COUNT(*) AS number_of_people
FROM users
GROUP BY age_group;

ALTER TABLE users MODIFY age INT;

SELECT 
    CASE 
        WHEN age BETWEEN 0 AND 5 THEN '0-5'
        WHEN age BETWEEN 6 AND 12 THEN '6-12'
        WHEN age BETWEEN 13 AND 19 THEN '13-19'
        WHEN age BETWEEN 20 AND 39 THEN '20-39'
        WHEN age BETWEEN 40 AND 59 THEN '40-59'
        ELSE '60+'
    END AS age_group,
    COUNT(*) AS number_of_people
FROM users
WHERE age IS NOT NULL
GROUP BY age_group;