You want to calculate the average sales per region and then find regions with average sales above 5000. Which approach using CTEs is best?

hard📝 Application Q8 of 15

SQL - Common Table Expressions (CTEs)

ACalculate average sales directly in main query without CTE

BUse a CTE to calculate average sales per region, then filter in main query

CCreate a temporary table instead of using a CTE

DUse a subquery inside WHERE clause without CTE

Step-by-Step Solution

Solution:

Step 1: Understand the problem
We need to calculate averages first, then filter regions based on that.
Step 2: Evaluate CTE usage
Using a CTE to calculate averages makes the query clearer and reusable for filtering.
Final Answer:
Use a CTE to calculate average sales per region, then filter in main query -> Option B
Quick Check:
CTEs simplify multi-step calculations and filtering [OK]

Quick Trick: CTEs help break complex queries into clear steps [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