性别信息与其他信息在同一字段内，故使用substring_index进行信息提取

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