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

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