题解 | 截取出年龄
截取出年龄
https://www.nowcoder.com/practice/b8d8a87fe1fc415c96f355dc62bdd12f
with temp as (
select
substring_index(substring_index(profile, ',', -2), ',', 1) as age
from user_submit
)
select distinct age, count(*) as number
from temp
group by age
order by age desc;
查看13道真题和解析