SELECT SUBSTRING_INDEX(profile,",",-1) AS gender ,COUNT(device_id) AS number
FROM user_submit
GROUP BY gender;