select substring_index(profile,',',-1)  as gender,count(device_id) as number
from user_submit
group by gender;
--主要是理解 substring_index函数，负数从右往左第N个分隔符右边全部内容，也就是-1的位置后面的male和female