select
    age_cut,
    count(device_id) as number
from
    (
        select
            if (ifnull (age, 0) < 25, "25岁以下", "25岁及以上") as age_cut,
            device_id
        from
            user_profile
    ) t1
group by
    age_cut;