Solution:Step 1: Understand subquery filteringThe subquery selects dept_id values where dept_name is 'Sales'.Step 2: Main query filters employeesThe main query selects employee names whose dept_id matches any dept_id from the subquery.Final Answer:Names of employees who work in the Sales department.

[Solved] Given the tables:Employees(emp_id, name, dept_id)Departments(dept_id, dept_name)What will this query return?... | SQL

SQL - Subqueries

Given the tables:
Employees(emp_id, name, dept_id)
Departments(dept_id, dept_name)
What will this query return?

SELECT name FROM Employees WHERE dept_id IN (SELECT dept_id FROM Departments WHERE dept_name = 'Sales');

ANames of employees who do not work in the Sales department.

BNames of employees who work in the Sales department.

CAll employee names regardless of department.

DAn error because subquery returns multiple rows.

Step-by-Step Solution

Solution:

Step 1: Understand subquery filtering
The subquery selects dept_id values where dept_name is 'Sales'.
Step 2: Main query filters employees
The main query selects employee names whose dept_id matches any dept_id from the subquery.
Final Answer:
Names of employees who work in the Sales department. -> Option B
Quick Check:
IN filters employees by Sales dept_id [OK]

Quick Trick: IN filters rows matching subquery values [OK]

Common Mistakes:

MISTAKES

Thinking it returns employees outside Sales
Assuming subquery causes error with multiple rows
Ignoring subquery filtering condition

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

Given the tables:

Step 1: Understand subquery filtering

Step 2: Main query filters employees

Final Answer:

Quick Check:

Want More Practice?