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