select 
substring_index(substring_index(profile,',',-2),',',1) as age,//使用两次字符串截取
count(device_id) as number
from user_submit
group by age