Count employees in each department.
Asked in the technical stage. This was a live SQL round using an Employees/Departments schema, with screen sharing and the query output pasted in chat.
department_name and employee_count.department_name.| Column | Type | Description |
|---|---|---|
| department_idPK | INT | Unique department identifier |
| department_name | VARCHAR(100) | Department name |
| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(150) | Employee full name |
| department_id | INT | Department assigned to the employee |