SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(profile,",",-2),",",1) AS age,
COUNT(device_id) AS number
FROM user_submit
GROUP BY age;

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(profile,",",-2),",",1) AS age,
COUNT(device_id) AS number
FROM user_submit
GROUP BY age;