题解 | #查看不同年龄段的用户明细#

SELECT
    device_id,
    gender,
    CASE
        WHEN age>=25 THEN '25岁及以上'
        WHEN age between 20 and 24 THEN '20-24岁'
        WHEN age <20 THEN '20岁以下'
        ELSE '其他'
        END as `age_cut`
FROM
    user_profile