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

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