Getting everything ready for you…

Loading courses, problems and your progress. This takes just a moment.

0s

SQL practice › Joins & grouping

Departments With No Employees

Medium · Joins & grouping

Return the name of every department that has no employees.

Hint

A LEFT JOIN keeps departments without a match; the employee columns are then NULL.

Write your query on this page — it runs against the sample company database in your browser and is checked instantly.

Next problem: Employee and Department