1270. All People Report to the Given Manager ¶

SQL

SELECT Employee.employee_id
FROM Employees AS Employee
INNER JOIN Employees AS DirectManager
  ON (Employee.manager_id = DirectManager.employee_id)
INNER JOIN Employees AS SkipManager
  ON (DirectManager.manager_id = SkipManager.employee_id)
WHERE
  SkipManager.manager_id = 1
  AND Employee.employee_id != 1;