Each employee's level in the hierarchy
In the org chart emp (employee → manager via manager_id), compute each one's level: the topmost (no manager) is level 1, their reports are 2, and so on down. Return id and depth, 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 | depth |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 2 |
Log ind for at se indsendelseshistorik
Log indLog ind for at bruge AI-mentor
Log ind