```WITH t AS ( SELECT *, CASE WHEN age > 24 THEN "25岁及以上" WHEN 20 <= age <= 24 THEN "20-24岁" ELSE "其他" END age_cnt FROM user_profile ) SELECT
device_id,
gender,
age_cnt 
FROM
	t;