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

Loading playground environment...

Hint

Solution

Next Problem