Solution:Step 1: Understand that views with GROUP BY are not updatableViews that aggregate data cannot be inserted into directly.Step 2: Identify the query that tries to insert dataINSERT INTO sales_summary (region, total_sales) VALUES ('East', 5000); tries to INSERT into the view, which will cause

[Solved] Given the view:CREATE VIEW sales_summary AS SELECT region, SUM(amount) AS total_sales FROM sales GROUP BY region;Which query will cause an error? | SQL

SQL - Views

Given the view:

CREATE VIEW sales_summary AS SELECT region, SUM(amount) AS total_sales FROM sales GROUP BY region;

Which query will cause an error?

ASELECT region, total_sales FROM sales_summary WHERE total_sales > 1000;

BSELECT * FROM sales_summary;

CSELECT region FROM sales_summary WHERE total_sales < 500;

DINSERT INTO sales_summary (region, total_sales) VALUES ('East', 5000);

Step-by-Step Solution

Solution:

Step 1: Understand that views with GROUP BY are not updatable
Views that aggregate data cannot be inserted into directly.
Step 2: Identify the query that tries to insert data
INSERT INTO sales_summary (region, total_sales) VALUES ('East', 5000); tries to INSERT into the view, which will cause an error.
Final Answer:
INSERT INTO sales_summary (region, total_sales) VALUES ('East', 5000); -> Option D
Quick Check:
Inserting into aggregated view causes error [OK]

Quick Trick: Aggregated views cannot be inserted into [OK]

Common Mistakes:

MISTAKES

Trying to insert into aggregated views
Confusing SELECT with INSERT
Assuming all views are updatable

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 view:

Step 1: Understand that views with GROUP BY are not updatable

Step 2: Identify the query that tries to insert data

Final Answer:

Quick Check:

Want More Practice?