```WITH t AS ( SELECT *, SUBSTRING_INDEX( PROFILE, ',',- 1 ) gender FROM user_submit ) SELECT
gender,
count( gender ) number 
FROM
	t 
GROUP BY
	gender;