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 every employee whose department contains at least one TRUE manager — someone who has at least one direct report. Use correlated EXISTS over employees.manager_id. Return employee_id, first_name, last_name, department_name — ordered by department_name, employee_id.

Relevant Tables

employeesdepartments

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Subquery Types & ClassificationSubqueries & CTEs
Correlated SubqueriesSubqueries & CTEs
Common Table ExpressionsSubqueries & CTEs