题解 | #截取出年龄#

select left(a,2) age,count(1) from 
(select substring_index(profile,',',-2) a from user_submit )b 
group by age;