Solution:Step 1: Analyze the subqueryThe subquery returns all dept_id values where location is 'NY'.Step 2: Understand the main query filterThe main query selects employee names whose dept_id is in the list returned by the subquery.Final Answer:Employees working in departments located in NY -> Opti

[Solved] Consider the query:SELECT emp_name FROM employees WHERE dept_id IN (SELECT dept_id FROM departments WHERE location = 'NY');What does this query return? | SQL

SQL - Subqueries

Consider the query:

SELECT emp_name FROM employees WHERE dept_id IN (SELECT dept_id FROM departments WHERE location = 'NY');

What does this query return?

AEmployees working outside NY

BEmployees working in departments located in NY

CAll employees regardless of location

DError because subquery returns multiple rows

Step-by-Step Solution

Solution:

Step 1: Analyze the subquery
The subquery returns all dept_id values where location is 'NY'.
Step 2: Understand the main query filter
The main query selects employee names whose dept_id is in the list returned by the subquery.
Final Answer:
Employees working in departments located in NY -> Option B
Quick Check:
IN with subquery filters employees by department location [OK]

Quick Trick: IN allows subquery to return multiple values for filtering [OK]

Common Mistakes:

MISTAKES

Thinking subquery with multiple rows causes error with IN
Confusing location filter with employee location
Assuming all employees are returned

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Consider the query:

Step 1: Analyze the subquery

Step 2: Understand the main query filter

Final Answer:

Quick Check:

Want More Practice?