题解 | 截取出年龄

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