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