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

#法一：使用模糊查询like和case when函数
select 
case when profile like "%,male" then 'male'
    when profile like "%,female" then 'female'
    end as gender, 
    count(*) from user_submit group by gender 
#法二，使用substring_index函数
select substring_index(profile, ",", -1) as gender, count(*) as number from user_submit group by gender