Employees Per Department Query

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Employees Per Department Query. Start with the requirements and the two tables on the right.

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

You need to log in / sign up to run or submit.

Problem

Auto-Owners Insurance maintains department and employee records for internal workforce reporting. Write a PostgreSQL query that returns the total number of employees assigned to each department.

Requirements

Include every department, including departments with no matching employees.
Count employees per department using an aggregation.
Sort results by employee count descending, then department name ascending for ties.

Schema

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's name
department_id	INT	Assigned department identifier
employment_status	VARCHAR(20)	Current employment status

Tablesdepartmentsemployees

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results