题解 | #统计每种性别的人数#
统计每种性别的人数
https://www.nowcoder.com/practice/f04189f92f8d4f6fa0f383d413af7cb8
select if(u.profile like '%female' ,'female',"male") as gender,count(u.device_id) from user_submit u group by gender
统计每种性别的人数
https://www.nowcoder.com/practice/f04189f92f8d4f6fa0f383d413af7cb8
select if(u.profile like '%female' ,'female',"male") as gender,count(u.device_id) from user_submit u group by gender
相关推荐
橙子飞行术:日常实习就是现在缺牛马了要招个人打杂 结果你说两个月后到 人家肯定不知道2个月后还需不需要一个打杂的啊。而且你现在想找实习,如果奔着就业去的 还管期末考干啥 考前一天看看不就行了 你985学历找实习嘎嘎乱杀的