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