正确题解:
select case when age<25 or age is null then '25岁以下' when age>=25 then '25岁及以上' end as age_cut, count(device_id) as number from user_profile group by age_cut #忘记group by
注意case then的格式