select
'25岁以下' as age_cut,
count(distinct device_id) as 'number'
from
user_profile
where
age < 25
or age is null
union
select
'25岁及以上' as age_cut,
count(distinct device_id) as 'number'
from
user_profile
where
age >= 25

京公网安备 11010502036488号