Problem 9 of 11 · Recursive CTEs & HierarchiesNext: Raw materials for a production run

00:00

Practice / SQL / Recursive CTEs & Hierarchies

WorkingGuided

HardAbout 14 minRecursive CTEs & HierarchiesLesson: Recursive CTEs & Hierarchies (P21) →

Total reports (direct + indirect) per manager

For every manager, count how many employees sit below them at any depth. Return only managers with at least one report. Columns: manager (the emp_id), reports. Sort by manager.

Columns

employees3 columns

columntype

emp_idVARCHAR

nameVARCHAR

manager_idVARCHAR

The table

7 rows · 3 columns

employeesfirst 5 of 7 rows

emp_idnamemanager_id

e1AliceNULL

e2Bobe1

e3Carole1

e4Dane2

e5Erine2

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows