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