select profile_gender gender,count(*) number
from (
    select substr(profile,15) profile_gender
    from user_submit
)a
group by profile_gender