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

select if(right(profile,5)=',male','male','female') as gender,
       count(device_id) as number
from user_submit
group by gender

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