题解 | 统计每种性别的人数
select case when profile like '%female%' then 'female' else 'male' end as gender ,count(device_id) as number from user_submit group by gender
select case when profile like '%female%' then 'female' else 'male' end as gender ,count(device_id) as number from user_submit group by gender
相关推荐