Find Cumulative Salary of an Employee

Given an employee table with manager relationships and salaries, compute for each employee the total salary of themselves plus all direct and indirect subordinates; the core challenge is traversing a self-referential hierarchy (tree/forest) efficiently. This typically requires recursive traversal (DFS/recursive CTE) to aggregate sums across multiple levels while handling deep nesting and multiple roots.