select "male" as gender,count(profile) from user_submit where right(profile,6)<>"female" union ALL select "female" as gender,count(profile) from user_submit where right(profile,6)="female"