Solution:Step 1: Analyze subqueryThe subquery returns dept_id(s) where dept_name is 'Marketing'.Step 2: Main query filteringThe main query selects employee names whose dept_id matches those returned by the subquery.Final Answer:Names of employees who work in the Marketing department -> Option BQuick

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

SQL - Subqueries

Given 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 = 'Marketing');

ANames of all employees regardless of department

BNames of employees who work in the Marketing department

CNames of employees who do not work in Marketing

DNames of departments named Marketing

Step-by-Step Solution

Solution:

Step 1: Analyze subquery
The subquery returns dept_id(s) where dept_name is 'Marketing'.
Step 2: Main query filtering
The main query selects employee names whose dept_id matches those returned by the subquery.
Final Answer:
Names of employees who work in the Marketing department -> Option B
Quick Check:
IN filters employees by Marketing dept_id(s) [OK]

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

Common Mistakes:

MISTAKES

Assuming it returns all employees
Confusing department names with employee names
Ignoring the WHERE clause in subquery

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

Step 1: Analyze subquery

Step 2: Main query filtering

Final Answer:

Quick Check:

Want More Practice?