题解 | #统计每种性别的人数#

select substr(profile,15,6) as gender,count(device_id) as number
from user_submit
group by gender;