Solution:Step 1: Understand the subqueryThe subquery selects department_id from departments where name is 'Sales'. This returns IDs of Sales departments.Step 2: Apply subquery results in main queryThe main query selects employee names where their department_id matches any of those returned by the su

[Solved] Given the tables:employees(emp_id, name, department_id)departments(department_id, name)What will this query return?... | SQL

SQL - Subqueries

Given the tables:
employees(emp_id, name, department_id)
departments(department_id, name)
What will this query return?

SELECT name FROM employees WHERE department_id IN (SELECT department_id FROM departments WHERE name = 'Sales');

ANames of employees who work in the Sales department

BNames of all employees

CNames of departments named Sales

DAn error because subquery returns multiple rows

Step-by-Step Solution

Solution:

Step 1: Understand the subquery
The subquery selects department_id from departments where name is 'Sales'. This returns IDs of Sales departments.
Step 2: Apply subquery results in main query
The main query selects employee names where their department_id matches any of those returned by the subquery.
Final Answer:
Names of employees who work in the Sales department -> Option A
Quick Check:
Subquery filters employees by Sales department [OK]

Quick Trick: Subquery filters department IDs, main query filters employees [OK]

Common Mistakes:

MISTAKES

Thinking subquery returns employee names
Confusing department names with employee names
Assuming subquery causes error with multiple rows

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 the subquery

Step 2: Apply subquery results in main query

Final Answer:

Quick Check:

Want More Practice?