coders.sh *

Loading Developers Heaven

The Org Chart Leak

Mission brief

Challenge Briefing

Hard

Recursive CTEs
Hierarchy

An anonymous internal report has surfaced, exposing the hidden hierarchy in our company. Management wants to know exactly how deep the "reporting chain" goes for one specific engineer: Dave. Your task is to count every management layer between Dave and the absolute top (the CEO).

The Org Chart Leak

Reconstruct the full reporting chain for a specific developer.

The Narrative

Schema Diagram

employees

idINT

nameVARCHAR

manager_idINT

Challenge a Friend

One SQL table. One SQL condition.
Still tricky for most developers.

SQL Editor

Terminal Output

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

Try another challenge

Similar difficulty and topics — pick up where you left off or stretch your SQL skills.

View all

Title	Complexity	Status	Solve
The Shadow Follower	Hard	Not solved	Solve
The Data Leaker	Hard	Not solved	Solve
The Recursive Tree	Hard	Not solved	Solve