People AnalyticsHard
Find every employee under a given manager using recursive SQL.
Seen at: Google People Ops · Workday · Meta · Visier
Given employees(employee_id, manager_id, name, department, level), write SQL that returns every direct and indirect report under a given top-level manager (say, employee_id = 42). Return each employee with their reporting-chain depth.
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Reveals the model answer and the self-score rubric.