题解 | 截取出年龄
截取出年龄
https://www.nowcoder.com/practice/b8d8a87fe1fc415c96f355dc62bdd12f
select
substring(replace(sub,substring_index(sub,",",-1),""),1,length(replace(sub,substring_index(sub,",",-1),""))-1) age
,count(*) as number
from
(
select substring_index(profile,",",-2) sub
from user_submit
) s
group by age
屎山，但有效
查看11道真题和解析