SELECT CASE WHEN age >= 25 THEN '25岁及以上' ELSE '25岁以下' END age_cut, COUNT(*) number FROM user_profile GROUP BY CASE WHEN age >= 25 THEN '25岁及以上' ELSE '25岁以下' END;
SELECT CASE WHEN age >= 25 THEN '25岁及以上' ELSE '25岁以下' END age_cut, COUNT(*) number FROM user_profile GROUP BY CASE WHEN age >= 25 THEN '25岁及以上' ELSE '25岁以下' END;