SELECT
CASE
when age<25 or age IS null then "25岁以下"
when age>=25 then "25岁及以上"
end age_cut,
count(*) number
FROM user_profile
GROUP BY age_cut;
SELECT
CASE
when age<25 or age IS null then "25岁以下"
when age>=25 then "25岁及以上"
end age_cut,
count(*) number
FROM user_profile
GROUP BY age_cut;