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

select case when profile like '%,male' then 'male' else 'female' end gender,count(device_id) number from user_submit group by gender

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

# select case when substring(profile,15,4)='male' then 'male' else 'female' end gender,count(device_id) number from user_submit group by gender

# select case when substring_index(profile,',',-1)='male' then 'male' else 'female' end gender,count(device_id) number from user_submit group by gender

# select substring_index(profile,',',-1) gender,count(device_id) number from user_submit group by gender

原本想用charindex函数划分出来的，没想到好像权限不够