(1)用if嵌套:select device_id,gender,
if(age<20,'20岁以下',if(age>=25,'25岁及以上',if(age is null,'其他','20-24岁')))age_cut
from user_profile
(2)用case:
select
    device_id,
    gender,
    case
        when age>=25 then '25岁及以上'
        when age>=20 then '20-24岁'
        when age<20 then '20岁以下'
        else '其他'
    end as age_cut
from user_profile