题解 | #截取出年龄#

 -- 使用SUBSTRING_INDEX(x1,x2,x3)分割两次即可
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(profile,',', 3),',', -1)AS age ,COUNT(*) number
FROM
    user_submit
GROUP BY age;