题解 | #计算25岁以上和以下的用户数量#
提取博客URL中的用户名
http://www.nowcoder.com/practice/26c8715f32e24d918f15db69518f3ad8
SELECT
'25岁以下' as age_cut,
count(id) as Number
FROM user_profile
WHERE age < 25 OR age is NULL
UNION
SELECT
'25岁及以上' as age_cut,
count(id) as Number
FROM user_profile
WHERE age >= 25
哔哩哔哩公司氛围 99人发布