题解 | #截取出年龄#

SELECT
    SUBSTRING_INDEX(SUBSTRING_INDEX(profile,',',3),',',-1) AS age,
    COUNT(device_id) AS number
FROM user_submit
GROUP BY age