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

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

本题主要是按照性格分组，而性别的相关字段包含在profile属性中，可以通过模糊匹配来获取不同性别，注意使用模糊匹配%male%时，female也会被匹配到，所以直接匹配%female%，其余情况就是 male.