题解 | #截取出年龄#

select age
     , count(1) as number
from (select substring_index(substring_index(profile, ',', -2), ',', 1) as age
      from user_submit) as f
group by age