SQL: Count Employees by Department | Dataford Interview Questions

Kovai's employee directory needs a department-level headcount for workforce reporting. Write a PostgreSQL query that counts employees in each department from the employees table.

Requirements

Return one row per department with the department name and employee count.
Include employees whose department is not assigned under the label Unassigned.
Sort the results alphabetically by department label.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department_name	VARCHAR(100)	Employee's department

Your question is SQL: Count Employees by Department. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Kovai's employee directory needs a department-level headcount for workforce reporting. Write a PostgreSQL query that counts employees in each department from the employees table.

Requirements

Return one row per department with the department name and employee count.
Include employees whose department is not assigned under the label Unassigned.
Sort the results alphabetically by department label.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department_name	VARCHAR(100)	Employee's department

Your question is SQL: Count Employees by Department. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.