coders.sh *

Loading Developers Heaven

The Recursive Tree

Mission brief

Challenge Briefing

Hard

CTE
Recursion
Hierarchical Queries

The company's HR portal has crashed, and the org chart data is now trapped in a flat SQL table. Management needs a report that reconstructs the hierarchy, showing every employee along with their seniority "Level." This is crucial for setting up a new permissions system across the organization.

The Recursive Tree

Map the hierarchical structure of a company starting from the CEO.

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 Referral Loop	Hard	Not solved	Solve