Skip to content
SQLSimplified
mediumemployeesself-joingroup-by

Managers and Their Reports

Problem

Return each manager's name and the number of direct reports they have, ordered by report_count descending.

Try It

Employees & Departments

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems