Solution:Step 1: Understand the subqueryThe subquery finds the dept_id for the department named 'HR'.Step 2: Apply the subquery result in the outer queryThe outer query selects employee names whose dept_id matches the HR dept_id.Final Answer:Names of employees who work in the HR department -> Option

[Solved] Given tables:Employees(emp_id, name, dept_id)Departments(dept_id, name)What will this query return?SELECT name FROM Employees WHERE dept_id = (SELECT dept_id FROM Departments WHERE name = 'HR'); | SQL

SQL - Subqueries

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

SELECT name FROM Employees WHERE dept_id = (SELECT dept_id FROM Departments WHERE name = 'HR');

ANames of all employees

BNames of employees who work in the HR department

CNames of employees who do not work in HR

DAn error because subquery returns multiple rows

Step-by-Step Solution

Solution:

Step 1: Understand the subquery
The subquery finds the dept_id for the department named 'HR'.
Step 2: Apply the subquery result in the outer query
The outer query selects employee names whose dept_id matches the HR dept_id.
Final Answer:
Names of employees who work in the HR department -> Option B
Quick Check:
Subquery filters employees by HR dept_id = Names of employees who work in the HR department [OK]

Quick Trick: Subquery filters outer query rows by matching values [OK]

Common Mistakes:

MISTAKES

Assuming subquery returns multiple rows error
Selecting all employees ignoring filter
Confusing employees not in HR

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

Step 2: Apply the subquery result in the outer query

Final Answer:

Quick Check:

Want More Practice?