题解 | 截取出年龄
截取出年龄
https://www.nowcoder.com/practice/b8d8a87fe1fc415c96f355dc62bdd12f
# select
# substring_index(substring_index(profile,',',3),',',-1) as age,
# count(device_id) as number
# from
# user_submit
# group by age;
select
substring_index(substring_index(profile,',',-2),',',1) as age,
count(device_id) as number
from
user_submit
group by
age;
，不说了，我又接了一单