[Solved] Given the tables employees(id, name) and departments(id, name, manager_id), what will this query return?SELECT e.name FROM employees e WHERE e.id IN (SELECT d.manager_id FROM departments d); | SQL

SQL - Subqueries

Given the tables employees(id, name) and departments(id, name, manager_id), what will this query return?

SELECT e.name FROM employees e WHERE e.id IN (SELECT d.manager_id FROM departments d);

ASyntax error due to subquery.

BNames of all employees regardless of department.

CNames of employees who are not managers.

DNames of employees who are managers of any department.

Step-by-Step Solution

Solution:

Step 1: Understand the subquery
The subquery SELECT d.manager_id FROM departments d returns all manager IDs from departments.
Step 2: Analyze the main query
The main query selects employee names where their ID is in the list of manager IDs, so it returns employees who manage departments.
Final Answer:
Names of employees who are managers of any department. -> Option D
Quick Check:
Subquery filters managers = Names of employees who are managers of any department. [OK]

Quick Trick: IN with subquery filters matching IDs [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the tables employees(id, name) and departments(id, name, manager_id), what will this query return?