Home
/
Questions
/
Coding
/
Every employee's full reporting chain
caseSQL
Coding question · Self Join Pairs
Very Hard
Asked at Google
Every employee's full reporting chain
Recursive CTE that builds a path array alongside depth.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Bucket customers into spend quartiles
Next →
2024 revenue grid: month × category