题解 | #截取出年龄#
截取出年龄
https://www.nowcoder.com/practice/b8d8a87fe1fc415c96f355dc62bdd12f
select t1.age,count(t1.age) from (select substring_index(substring_index(profile, ',',3),',',-1) as age from user_submit )as t1 group by t1.age
substring_index用法要牢记
Reference：https://blog.csdn.net/weixin_50853979/article/details/124669207
汤臣倍健二面21人在聊