Level 2 - Question 7: Find Departments Without Employees

Scenario

A report is needed to find all departments that currently have no employees assigned.

Task

Write a SQL query that returns department_name from departments table that have no match in the employees table.

Sample Schema

employees	departments
emp_id employee_name department_id	department_id department_name

Write Your SQL Answer:

Submit Answer