How can you modify a recursive CTE to calculate the total salary cost of all employees under each manager recursively?

hard📝 Application Q9 of 15

SQL - Common Table Expressions (CTEs)

AAdd salary in anchor member only, ignore recursive member

BCalculate salary totals only in the final SELECT using GROUP BY

CAdd a salary column in anchor and recursive members, summing salaries as recursion progresses

DUse a window function instead of recursion to sum salaries

Step-by-Step Solution

Solution:

Step 1: Include salary in anchor and recursive queries
Pass salary values along recursion to accumulate totals.
Step 2: Sum salaries progressively
Use addition in recursive member to accumulate salary sums per manager.
Final Answer:
Add a salary column in anchor and recursive members, summing salaries as recursion progresses -> Option C
Quick Check:
Accumulate values during recursion for totals [OK]

Quick Trick: Sum values inside recursive member to accumulate totals [OK]

Common Mistakes:

Master "Common Table Expressions (CTEs)" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes