题解 | #统计每种性别的人数#
统计每种性别的人数
https://www.nowcoder.com/practice/f04189f92f8d4f6fa0f383d413af7cb8
SELECT
SUBSTRING_INDEX(profile,',',-1) AS gender,
COUNT(*) AS number
FROM user_submit
GROUP BY gender;
#PS:这里用COUNT(*)其实不太准确，为防止有人重复提交申请，用COUNT(DISTINCT device_id)更准确一些，不过与这道题设置的答案顺序不一样，运行时会通不过
查看6道真题和解析
