题解 | 查看不同年龄段的用户明细
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
相关推荐