题解 | 统计每种性别的人数
统计每种性别的人数
https://www.nowcoder.com/practice/f04189f92f8d4f6fa0f383d413af7cb8
select substring_index(profile,',',-1) as gender, count(*) as number from user_submit group by gender
SUBSTRING_INDEX(str, delim, count)
负数:从右往左数,返回后 count 个分隔符之后的内容。