SELECT SUBSTRING(profile FROM 15 FOR 6)AS gender,COUNT(device_id) FROM user_submit GROUP BY gender;

profile FROM 15 FOR 6 /*字符串的提取，SUBSTRING(对象字符串 FROM 截取的起始位置 FOR 截取的字符串)；