select case when profile rlike 'female$' then 'female' else 'male'
end as gender,count(*) as number
from user_submit
group by gender;