题主省略了二个as SELECT CASE WHEN age<25 or age is null then '25岁以下' WHEN age>=25 then '25岁及以上' end as age_cut, COUNT(*) as number FROM user_profile GROUP BY age_cut;
1

相关推荐

牛客网
牛客企业服务