select regexp_substr(profile,'[^,]+',1,4) gender, count(*)  
from user_submit 
group by regexp_substr(profile,'[^,]+',1,4)