题解 | 计算25岁以上和以下的用户数量
计算25岁以上和以下的用户数量
https://www.nowcoder.com/practice/30f9f470390a4a8a8dd3b8e1f8c7a9fa
SELECT
CASE
WHEN age < 25
OR age IS NULL THEN '25岁以下'
ELSE '25岁及以上'
END AS age_cut,
COUNT(*) AS number
FROM
user_profile
GROUP BY
age_cut;
# SELECT
# IF(age >= 25, '25岁及以上', '25岁以下') AS age_cut,
# COUNT(*) AS number
# FROM user_profile
# GROUP BY age_cut;
智元机器人成长空间 270人发布
，接着当手孝子
