题解 | #统计每种性别的人数#
select (substring_index(profile, ',', -1)) as gender, count(device_id) as number
from user_submit
group by gender;
select (substring_index(profile, ',', -1)) as gender, count(device_id) as number
from user_submit
group by gender;
相关推荐