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

select
    gender
    ,count(*) number
from
    (select 
        device_id
        ,case
            when INSTR(profile, 'female') then 'female'
            else 'male' end as gender
        from 
        user_submit) gender_info
group by gender