select case when right(profile, 6) = 'female' then 'female' 
            else 'male' 
        end as gender,
        count(*)

from user_submit

group by gender