Headcount per org level
«Company structure by hierarchy level» report: how many people sit on level 1 (the CEO), on level 2 (their direct reports), on level 3 (those reports' reports), and so on. For every level compute the headcount and show two columns: level number and the number of people at that level. Sort by level number.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| level | headcount |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in