By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| EmployeeID | EmployeeName | Salary | TotalSubordinateSalaries |
|---|---|---|---|
| 1 | John | 10000.00 | 15500.00 |
| 2 | Alice | 7500.00 | null |
| 3 | Bob | 8000.00 | null |
| 1000 | Eve | 6000.00 | null |
| EmployeeID | EmployeeName | Salary | TotalSubordinateSalaries |
|---|---|---|---|
| 1 | John | 10000.00 | 15500.00 |
| 2 | Alice | 7500.00 | null |
| 3 | Bob | 8000.00 | null |
| 1000 | Eve | 6000.00 | null |