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

SELECT substring_index(profile, ',', -1) AS gender, 
        count(*) AS number
FROM user_submit
GROUP BY gender;