题解 | 计算25岁以上和以下的用户数量
计算25岁以上和以下的用户数量
https://www.nowcoder.com/practice/30f9f470390a4a8a8dd3b8e1f8c7a9fa
select
"25岁以下" as age_cnt,
sum(case
when age < 25 then 1
when age is null then 1
else 0
end)
from user_profile
union
select
"25岁及以上" as age_cnt,
sum(case
when age >=25 then 1
else 0
end
)
from user_profile