select regexp_substr(profile,'male|female') as gender,
count(*) as number 
from user_submit
group by gender;