mysql - 统计各部门用户

Question

我有一个具有以下布局的表格:

+----+-----------+-------------+| id | name      | department  |+----+-----------+-------------+|   1| John      | Finance     |+----+-----------+-------------+|   2| Bob       | Optics      |+----+-----------+-------------+|   3| Jill      | Finance     |+----+-----------+-------------+|   4| Jake      | Finance     |+----+-----------+-------------+|   5| Mike      | Support     |+----+-----------+-------------+

我想得到每个部门所有人员的总和:

+-----------+-------------+| people    | department  |+-----------+-------------+|          3| Finance     |+-----------+-------------+|          1| Optics      |+-----------+-------------+|          1| Support     |+-----------+-------------+

我在构造正确的查询时遇到问题

Answer 1

使用 COUNT

SELECT COUNT(name),department FROM table GROUP BY department