The people team is doing org planning and needs a headcount by department. Using the employees table, return the number of employees in each department, ordered from largest to smallest.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | INTEGER |
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 120000 |
| 2 | Bob | Marketing | 85000 |
| 3 | Carol | Engineering | 135000 |
| 4 | Dave | HR | 72000 |
| 5 | Eve | Engineering | 115000 |
| 6 | Frank | Marketing | 90000 |
| 7 | Grace | HR | 68000 |
| 8 | Heidi | Engineering | 140000 |
| department | headcount |
|---|---|
| Engineering | 4 |
| HR | 2 |
| Marketing | 2 |
Engineering has four employees, while HR and Marketing each have two. Results are ordered by headcount descending.