select
    device_id,
    gender,
	#多种情况使用when在case中分别讨论
    (
        case
            when age < 20 then '20岁以下'
            when age between 20 and 24  then '20-24岁'
            when age >= 25 then '25岁及以上'
            else '其他'
        end
    ) as age_cut
from
    user_profile;