#sql中分割字符串的方法
select 
SUBSTRING_INDEX(profile,',',-1) as gender,
COUNT(device_id) as NUMBER
from user_submit
group by gender;