SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Departments with Managers (Semi-Join)

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

Problem Statement

Find departments that have at least one manager using EXISTS.

Relevant Tables

departmentsemployees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: