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