How would you find all employees in a reporting hierarchy under a specific manager (any depth)?

WITH RECURSIVE subordinates AS (-- Anchor: direct reports of manager with id=1 SELECT emp_id, first_name, manager_id, 1 AS level FROM employees WHERE manager_id = 1 UNION ALL -- Recursive: find reports of reports SELECT e.emp_id, e.first_name, e.manager_id, s.level + 1 FROM employees e JOIN subordinates s ON e.manager_id = s.emp_id WHERE s.level < 10 -- safety limit) SELECT emp_id, first_name, lev