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

select device_id , gender ,
    (case when age<20 or age is null then "其他"
        when age >=20 && age <=24 then "20-24岁"
        else  "25岁及以上" end) as age_cut from user_profile;