select age_type,count(*) as age_cnt
from
(select id,
       case when age<25 then '25岁以下'
       when age>=25 then '25岁及以上'
       when age is null then '25岁以下' end
       as age_type
from user_profile) a
group by age_type