mysql group by

查询学生表里男女各多少人

 select  sex,count(sex) from student group by sex;

+-----+------------+
| sex | count(sex) |
+-----+------------+
| 男  |          5 |
| 女  |          6 |
+-----+------------+