select if(substr(profile,15,1)="m","male","female") as gender,count(profile) as number
from user_submit
group by gender