Solution:Step 1: Understand the CTEThe CTE named TopSellers aggregates total sales per salesperson.Step 2: Analyze the main queryThe main query selects salespersons whose total sales are greater than 5000.Final Answer:To list salespersons with total sales exceeding 5000 -> Option BQuick Check:Check

[Solved] Given the SQL query:WITH TopSellers AS (SELECT salesperson, SUM(amount) AS total_sales FROM sales GROUP BY salesperson) SELECT salesperson FROM TopSellers WHERE total_sales > 5000;What is the purpose... | SQL

SQL - Common Table Expressions (CTEs)

Given the SQL query:

WITH TopSellers AS (SELECT salesperson, SUM(amount) AS total_sales FROM sales GROUP BY salesperson) SELECT salesperson FROM TopSellers WHERE total_sales > 5000;

What is the purpose of this query?

ATo calculate the average sales per salesperson

BTo list salespersons with total sales exceeding 5000

CTo find salespersons with sales less than 5000

DTo update sales records for salespersons

Step-by-Step Solution

Solution:

Step 1: Understand the CTE
The CTE named TopSellers aggregates total sales per salesperson.
Step 2: Analyze the main query
The main query selects salespersons whose total sales are greater than 5000.
Final Answer:
To list salespersons with total sales exceeding 5000 -> Option B
Quick Check:
Check the WHERE clause filtering total_sales > 5000 [OK]

Quick Trick: CTEs simplify aggregation and filtering [OK]

Common Mistakes:

Confusing SUM with AVG
Misinterpreting the WHERE clause condition
Assuming the query updates data

Master "Common Table Expressions (CTEs)" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given the SQL query:

Step 1: Understand the CTE

Step 2: Analyze the main query

Final Answer:

Quick Check:

Want More Practice?