Flatten Org Chart Hierarchy

A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

hard

Seniority

senior

Problem

Each employee has a manager_id pointing to their manager's employee_id (NULL for the CEO). Return every employee with their depth in the tree and the full path from CEO down, formatted like a file path with / between names. Results should follow path order.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.