题解 | #统计每种性别的人数#
统计每种性别的人数
https://www.nowcoder.com/practice/f04189f92f8d4f6fa0f383d413af7cb8
SELECT
(
case
when profile like '%,male' then 'male'
when profile like '%,female' then 'female'
end
) as gender,
count(profile) as number
from
user_submit
group by
gender
方法二：
select
if (profile like '%,female', 'female', 'male') as gender,
count(profile) as number
from
user_submit
group by
gender
查看1道真题和解析