题解 | #截取出年龄#

select  substring_index(substring_index(profile,',',-2), ',', 1) age, count(device_id) as number
from user_submit
group by age