Scenario SQL Question

Manager Team Summary

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

Problem Statement

For every employee who has at least one direct report, return their employee_id, first_name, last_name, team_size (number of direct reports), avg_team_salary (rounded to 2 decimals). Order by team_size DESC, employee_id.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
LEFT/RIGHT/FULL OUTER JOINJoins & Relationships
Multiple Table JoinsJoins & Relationships