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