(2001, 1001, DATEADD(DAY, -45, @today), 'Sydney-Melbourne', 'Economy', 80, 1200, 1), (2002, 1001, DATEADD(DAY, -60, @today), 'Melbourne-Brisbane', 'Economy', 100 ...
Problem: Starting from the HR department head (dept_id = 1, manager_id is NULL), list all employees in that reporting chain (head + all direct/indirect reports).