[Solved] What will be the output of this query?SELECT name FROM employees WHERE department_id IN (SELECT id FROM departments WHERE location = 'NY'); | PostgreSQL

PostgreSQL - Subqueries in PostgreSQL

What will be the output of this query?

SELECT name FROM employees WHERE department_id IN (SELECT id FROM departments WHERE location = 'NY');

ANames of employees working outside NY

BNames of all employees regardless of location

CNames of employees working in departments located in NY

DSyntax error due to missing JOIN

Step-by-Step Solution

Solution:

Step 1: Understand the subquery
The subquery selects department IDs where location is 'NY'.
Step 2: Main query filters employees by those department IDs
Only employees in those departments are selected.
Final Answer:
Names of employees working in departments located in NY -> Option C
Quick Check:
Subquery filters departments, main query filters employees [OK]

Quick Trick: Subqueries can filter main query results by related data [OK]

Common Mistakes:

Master "Subqueries in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the output of this query?