SELECT 
CASE 
WHEN age<25 OR age is NULL 
THEN '25岁以下'
WHEN age>=25
THEN '25岁及以上'
ELSE NULL
END AS age_cnt,
count(*) AS number
FROM user_profile
GROUP BY age_cnt;