题解 | 查看不同年龄段的用户明细
查看不同年龄段的用户明细
https://www.nowcoder.com/practice/ae44b2b78525417b8b2fc2075b557592
-- 返回device_id, gender, age_cut(分组类别) -- 多条件判断用CASE语法: -- CASE -- WHEN age < 20 THEN '20以下' -- WHEN age >= 20 AND age <=24 THEN '20-24岁' -- WHEN age >= 25 THEN '25岁及以上' -- ELSE '其他' -- END AS age_cut SELECT device_id, gender, CASE WHEN age < 20 THEN '20以下' WHEN age >= 20 AND age <= 24 THEN '20-24岁' WHEN age >= 25 THEN '25岁及以上' ELSE '其他' END AS age_cut FROM user_profile;