[Solved] What will be the output of this query?SELECT * FROM (SELECT EmployeeID, Salary FROM Employees WHERE Salary > 50000) AS HighEarners WHERE EmployeeID | SQL

SQL - Common Table Expressions (CTEs)

What will be the output of this query?

SELECT * FROM (SELECT EmployeeID, Salary FROM Employees WHERE Salary > 50000) AS HighEarners WHERE EmployeeID < 100;

AAll employees with salary > 50000

BEmployees with salary > 50000 and EmployeeID < 100

CSyntax error due to missing alias

DEmployees with EmployeeID < 100 regardless of salary

Step-by-Step Solution

Solution:

Step 1: Understand the subquery
The subquery selects employees with salary greater than 50000 and aliases it as HighEarners.
Step 2: Apply outer WHERE clause
The outer query filters those results to employees with EmployeeID less than 100.
Final Answer:
Employees with salary > 50000 and EmployeeID < 100 -> Option B
Quick Check:
Subquery filters first, outer query filters second [OK]

Quick Trick: Subquery filters first, outer query filters next [OK]

Common Mistakes:

Master "Common Table Expressions (CTEs)" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query?