select
    if (profile like '%female', 'female', 'male') as gender,
    COUNT(*) as number
from
    user_submit
group by
    if (profile like '%female', 'female', 'male');