题解 | #统计每种性别的人数#

select substring_index(profile,',',-1) as gender, count(device_id)as number
//substring_index(字段名称,'分隔符',第几位）
from user_submit
group by gender