SQL30 统计每种性别的人数

SUBSTRING_INDEX的写法

# 一般
select 
	gender,count(1) as number
from (
	select 
		substring_index(profile,',',-1) as gender 
	from user_submit ) as us
group by  us.gender 

#优秀
SELECT SUBSTRING_INDEX(profile,",",-1) gender,COUNT(*) number
FROM user_submit
GROUP BY gender;

#创意
select "male" as gender,count(profile) from user_submit where right(profile,6)<>"female"
union ALL
select "female" as gender,count(profile) from user_submit where right(profile,6)="female"