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).

Problem: Generate a sequence of integers starting at 1 and ending at 10 using a recursive CTE. Output: one column named num with values 1 through 10 (each number on its own row). Using a recursive CTE ...