select 
substring_index(substring_index(profile,',',-2),',',1) as age,count(device_id) as number
from user_submit group by age;
//详细看substring_index的使用规则