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

select 
    case when (profile like '%female%') then 'female'
         when (profile like '%male%') then 'male'
    end as gender,count(*)number
from user_submit
group by gender