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

select (case when profile like "%female%" then "female" else 'male' end ) as gender,
count(device_id) as number
from 
user_submit
group by gender