题解 | 统计每种性别的人数
统计每种性别的人数
https://www.nowcoder.com/practice/f04189f92f8d4f6fa0f383d413af7cb8
SELECT
(
CASE
WHEN profile LIKE '%,male' THEN 'male'
WHEN profile LIKE '%,female' THEN 'female'
END
) AS gender,
COUNT(*) AS number
FROM
user_submit
GROUP BY
gender
# 直接使用%male和%female可能产生歧义，因为"female"中也包含"male"子串，所以建议在模式匹配中加入逗号作为分隔符，如%,male和%,female
