题解 | 截取出年龄
截取出年龄
https://www.nowcoder.com/practice/b8d8a87fe1fc415c96f355dc62bdd12f
SELECT
SUBSTRING_INDEX(SUBSTRING_INDEX(profile, ',', -2), ',', 1) as age,
count(*) as number
FROM
user_submit
GROUP BY
SUBSTRING_INDEX(SUBSTRING_INDEX(profile, ',', -2), ',', 1)
ORDER BY
age desc;
查看6道真题和解析