select 
(case when age >=25 then '25岁及以上' else '25岁以下' end) as age_cnt,count(*) as number from user_profile 
group by age_cnt

case when 字段条件 then else end 或case 字段 when 字段条件 then end