[Solved] What will be the output of this query?SELECT e.name, d.department FROM employees e INNER JOIN departments d ON e.dept_id = d.id WHERE d.... | SQL

SQL - INNER JOIN

What will be the output of this query?

SELECT e.name, d.department FROM employees e INNER JOIN departments d ON e.dept_id = d.id WHERE d.location = 'NY';

Assuming departments has locations and employees have matching dept_id.

ADepartments in NY without employees

BAll employees regardless of location

CEmployees working only in NY departments

DEmployees without departments

Step-by-Step Solution

Solution:

Step 1: Analyze INNER JOIN with WHERE filter
The INNER JOIN matches employees to departments by dept_id, then filters departments located in NY.
Step 2: Result interpretation
Only employees in departments located in NY will appear in the result.
Final Answer:
Employees working only in NY departments -> Option C
Quick Check:
INNER JOIN + WHERE filters rows correctly [OK]

Quick Trick: WHERE filters after join, narrowing results [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query?