SQL32题解 | #截取出年龄#

SELECT 
SUBSTRING_INDEX(SUBSTRING_INDEX(profile, ',', -2), ',', 1) AS age,
count(*) AS number
FROM user_submit
GROUP BY age;