题解 | #统计每种性别的人数#
SELECT SUBSTRING_INDEX(profile, ',', -1) AS gender,count(device_id) AS number
一些不自量力