select 
    substring_index(profile,',',-1) as gender
    ,count(*)
from user_submit
group by 1