select 
    case 
    when profile like '%female%' then 'female'
    when profile like '%male%' then 'male'
    else '未知' end gender
    ,count(*)
from user_submit
group by 1