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;