查询学生表里男女各多少人
select sex,count(sex) from student group by sex;
+-----+------------+
| sex | count(sex) |
+-----+------------+
| 男 | 5 |
| 女 | 6 |
+-----+------------+
查询学生表里男女各多少人
select sex,count(sex) from student group by sex;
+-----+------------+
| sex | count(sex) |
+-----+------------+
| 男 | 5 |
| 女 | 6 |
+-----+------------+