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

select 'male' ,
count(sub.male) from (select SUBSTRING_INDEX(profile,',',-1) as male  from user_submit) sub where sub.male = 'male'
union all
select 'female' ,
count(sub.male) from (select SUBSTRING_INDEX(profile,',',-1) as male  from user_submit) sub where sub.male = 'female'

首先分析这个输出格式 得知female和male要分别输出 ，然后题意肯定要用到sql分割语句 所以使用子查询就能查出来