[Solved] What will be the output of this query?SELECT name FROM employees WHERE department_id = (SELECT id FROM departments WHERE name = 'Sales');Assuming the departments table has one row with name 'Sales'... | SQL

SQL - Subqueries

What will be the output of this query?

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

Assuming the departments table has one row with name 'Sales' and id 3, and employees table has:

id | name | department_id
1 | Alice | 3
2 | Bob | 2
3 | Carol | 3

ANo rows returned

BBob only

CAlice and Carol

DAlice, Bob, and Carol

Step-by-Step Solution

Solution:

Step 1: Find department id for 'Sales'
The subquery returns id = 3 for 'Sales' department.
Step 2: Select employees with department_id = 3
Employees Alice and Carol have department_id 3, so they are selected.
Final Answer:
Alice and Carol -> Option C
Quick Check:
Subquery returns 3, employees with department_id 3 selected [OK]

Quick Trick: Match subquery result with main query filter [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query?