select distinct gender, count(gender) number from ( select device_id, substring(profile, 15, length(profile)) as gender from user_submit ) as a group by a.gender
1

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务