题解 | #统计每种性别的人数#

-- SUBSTRING_INDEX(x1,x2,x3) x1 = 要截取的字符串 x2 = 分隔符 x3 = 截取位置
-- SUBSTRING(x1,x2) x1 = 要截取的字符串 x2 = 要截取的起始位置
SELECT SUBSTRING(profile,15) AS gender , COUNT(*) AS number
FROM user_submit
GROUP BY gender;