select substring_index(profile,',',-1) gender, count(*) number from user_submit group by gender
相关推荐