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

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