select
  substring_index(PROFILE, ',', -1) as gender,
  count(1) as number
from
  user_submit
group by
  gender