How many people report to a manager
For each manager in emp, count how many people are under them across all levels — direct and indirect reports. Return the manager id and the count reports, only for those with at least one report, ordered by id.
Eksempel på forventet output
Sådan ser et korrekt svar ud — dets rækketal er dets eget og behøver ikke at matche skematabellerne.
| id | reports |
|---|---|
| 1 | 6 |
| 2 | 3 |
| 3 | 1 |
Log ind for at se indsendelseshistorik
Log indLog ind for at bruge AI-mentor
Log ind