SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Employees in Departments with Managers

Build mastery in Subqueries with this scenario-based SQL challenge and live execution support.

Problem Statement

Find employees who work in departments that have at least one manager (employee with manager_id IS NULL).

Relevant Tables

employeesdepartments

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: