select substring(profile,15) as gender,count(device_id) as number
from user_submit
group by gender