题解 | 查看不同年龄段的用户明细
SELECT
device_id, gender,
CASE
WHEN age is NULL THEN '其他'
WHEN age < 20 THEN '20岁以下'
WHEN age <= 24 THEN '20-24岁'
ELSE '25岁及以上'
END age_cut
FROM user_profile
SELECT
device_id, gender,
CASE
WHEN age is NULL THEN '其他'
WHEN age < 20 THEN '20岁以下'
WHEN age <= 24 THEN '20-24岁'
ELSE '25岁及以上'
END age_cut
FROM user_profile
相关推荐