题解 | 截取出年龄
截取出年龄
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;
查看12道真题和解析
投递腾讯等公司10个岗位