select
   if(profile like '%female','female','male') as gender,
    count(device_id)
from
    user_submit
group by
    gender