select '25岁以下' as age_cnt, count(*)-sum(age >= 25) as number from user_profile union all select '25岁及以上' as age_cnt, count(device_id) as number from user_profile where age >= 25;