select u1.age_cut ,count(*) from (select case when u.age>=25 then '25岁及以上' else '25岁以下' end age_cut from user_profile u) u1 group by u1.age_cut ;