正确答案:
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