select device_id,gender,
case when age >=25 then "25岁及以上" 
     when age >=20 and age < 25 then "20-24岁"
     when age <20 then "20岁以下"
     else "其他" end as age_cut
from user_profile

标准的CASE WHEN 用法
比上一题简单