题解 | #计算25岁以上和以下的用户数量#

select (case 
when age<25 then "25岁以下"
when age>=25 then "25岁及以上"
else ifnull(age,"25岁以下")
end) as age_cut,count(*) 
from user_profile
group by age_cut