(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岁及以上' &n...