Scenario SQL Question

Find Managers with Most Direct Reports

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

Problem Statement

Find the top 3 managers by direct-report count. Exclude employees with zero reports. Return manager_id, manager_name, direct_reports_count — ordered by direct_reports_count DESC, manager_id.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Self JoinsJoins & Relationships
Recursive CTEs for Hierarchical DataSubqueries & CTEs
Common Table ExpressionsSubqueries & CTEs