[Solved] Given the table Sales with columns product, region, and amount, and the view:CREATE VIEW RegionalSales AS SELECT region, SUM(amount) AS total FROM Sales GROUP BY region;What will the query SELECT *... | SQL

SQL - Views

Given the table Sales with columns product, region, and amount, and the view:
CREATE VIEW RegionalSales AS SELECT region, SUM(amount) AS total FROM Sales GROUP BY region;
What will the query SELECT * FROM RegionalSales WHERE total > 1000; return?

AAll rows from Sales table without filtering

BRows showing regions where total sales amount is more than 1000

CSyntax error because views cannot use GROUP BY

DEmpty result because total is not a column in Sales

Step-by-Step Solution

Solution:

Step 1: Understand the view definition
The view groups sales by region and sums amounts, creating a total per region.
Step 2: Analyze the query on the view
The query filters regions where total sales exceed 1000, so it returns those regions and totals.
Final Answer:
Rows showing regions where total sales amount is more than 1000 -> Option B
Quick Check:
View groups and filters totals > 1000 = A [OK]

Quick Trick: Views can use GROUP BY and filters on aggregated columns [OK]

Common Mistakes:

MISTAKES

Thinking views cannot use GROUP BY
Confusing view columns with base table columns
Assuming syntax error due to alias

Master "Views" 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 table Sales with columns product, region, and amount, and the view:

Step 1: Understand the view definition

Step 2: Analyze the query on the view

Final Answer:

Quick Check:

Want More Practice?