题解 | #统计每种性别的人数#
统计每种性别的人数
http://www.nowcoder.com/practice/f04189f92f8d4f6fa0f383d413af7cb8
CASE + LIKE 方法
SELECT
CASE
WHEN profile LIKE '%,male' then 'male'
WHEN profile LIKE '%,female' then 'female'
else '其他'
end as gender,
COUNT(*) AS number
FROM user_submit
GROUP BY gender;
- 注意famale 和 male 有重合的地方，所以不能直接like male，否则female 也会被统计进 ‘male’
查看1道真题和解析