SELECT
(CASE WHEN age>=25 THEN '25岁及以上'
ELSE '25岁以下' END) AS age_cut,COUNT(device_id) as number
FROM user_profile
GROUP BY age_cut;
SELECT
(CASE WHEN age>=25 THEN '25岁及以上'
ELSE '25岁以下' END) AS age_cut,COUNT(device_id) as number
FROM user_profile
GROUP BY age_cut;
牛客博客，记录你的成长
京公网安备 11010502036488号