Employee management exercise 8

Back to Employee management

Select the number of employees in each department (you only need to show the department code and the number of employees).

| SELECT ssn, department FROM employees
| GROUP department, ssn COUNT BY department
4 rows 0 msec

department	ssn-count
14	5
37	2
59	3
77	2