正确题解:

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的格式