If a view is created as CREATE VIEW SalesSummary AS SELECT region, SUM(amount) AS total FROM Sales GROUP BY region;, what will SELECT * FROM SalesSummary; show?
medium📝 query result Q5 of 15
SQL - Views
If a view is created as CREATE VIEW SalesSummary AS SELECT region, SUM(amount) AS total FROM Sales GROUP BY region;, what will SELECT * FROM SalesSummary; show?
ASum of sales amounts grouped by region
BIndividual sales records without grouping
COnly the regions without any sales data
DAn error because aggregate functions cannot be used in views
Step-by-Step Solution
Solution:
Step 1: Understand the view's query
The view groups sales by region and calculates the sum of amounts per region.
Step 2: Predict the output of selecting from the view
Selecting all from the view returns each region with its total sales amount.
Final Answer:
Sum of sales amounts grouped by region -> Option A
Quick Check:
Views can include aggregates and grouping [OK]
Quick Trick:Views can summarize data using GROUP BY and aggregates [OK]
Common Mistakes:
MISTAKES
Thinking views cannot use aggregate functions
Expecting detailed individual records
Assuming error due to aggregation
Master "Views" in SQL
9 interactive learning modes - each teaches the same concept differently
