SQL26题解 | #计算25岁以上和以下的用户数量#

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