题解 | #统计每种性别的人数#
查看不同年龄段的用户明细
http://www.nowcoder.com/practice/ae44b2b78525417b8b2fc2075b557592
SELECT SUBSTRING_INDEX(profile,",",-1) gender,COUNT(*) number
FROM user_submit
GROUP BY gender;
查看不同年龄段的用户明细
http://www.nowcoder.com/practice/ae44b2b78525417b8b2fc2075b557592
SELECT SUBSTRING_INDEX(profile,",",-1) gender,COUNT(*) number
FROM user_submit
GROUP BY gender;
相关推荐