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;
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;