[Solved] Given a view high_salary defined as:CREATE VIEW high_salary AS SELECT name, salary FROM employees WHERE salary > 70000;What will this query return?SELECT * FROM high_salary WHERE salary > 80000; | SQL

SQL - Views

Given a view high_salary defined as:

CREATE VIEW high_salary AS SELECT name, salary FROM employees WHERE salary > 70000;

What will this query return?

SELECT * FROM high_salary WHERE salary > 80000;

ASyntax error because salary filter is repeated

BAll employees with salary greater than 70000

CAll employees with salary greater than 80000

DEmpty result because salary > 70000 is overridden

Step-by-Step Solution

Solution:

Step 1: Understand the view definition
The view returns employees with salary > 70000 only.
Step 2: Apply the query filter on the view
The query further filters those results to salary > 80000, so only employees with salary above 80000 are returned.
Final Answer:
All employees with salary greater than 80000 -> Option C
Quick Check:
View filters 70000+, query filters 80000+ [OK]

Quick Trick: Filters on views stack, narrowing results [OK]

Common Mistakes:

MISTAKES

Master "Views" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given a view high_salary defined as: