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

# select if(profile like '%male','male','female') gender,
# count(*) number
# from user_submit
# group by gender;

# SELECT IF(profile LIKE '%female','female','male') gender,COUNT(*) number
# FROM user_submit
# GROUP BY gender;

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