牛客网题目:
计算25岁以上和以下的用户数量
题解1:
select
case
when age < 25
or age is null then '25岁以下'
when age >= 25 then '25岁及以上'
end as age_cut,
count(*) as number
from
user_profile
group by
age_cut;
题解2:
select
if (
age < 25 or age is null, '25岁以下', '25岁及以上'
) as age_cut,
count(*) as number
from
user_profile
group by
age_cut;