Solution:Step 1: Identify matching rows by dept_idEmployees with dept_id 10 and 20 match Departments with same dept_id. Carol's dept_id 30 has no match.Step 2: Understand INNER JOIN outputINNER JOIN returns only rows with matching dept_id in both tables, so Carol is excluded.Final Answer:[('Alice',

[Solved] Given the tables:Employees(id, name, dept_id)Departments(dept_id, dept_name)What is the result of this query?SELECT name, dept_name FROM Employees INNER JOIN Departments ON Employees.... | SQL

SQL - INNER JOIN

Given the tables:
Employees(id, name, dept_id)
Departments(dept_id, dept_name)
What is the result of this query?

SELECT name, dept_name FROM Employees INNER JOIN Departments ON Employees.dept_id = Departments.dept_id;

Assuming:
Employees: (1, 'Alice', 10), (2, 'Bob', 20), (3, 'Carol', 30)
Departments: (10, 'HR'), (20, 'Sales')

A[('Alice', 'HR'), ('Bob', 'Sales')]

B[('Alice', 'HR'), ('Bob', 'Sales'), ('Carol', '30')]

C[('Alice', 'HR'), ('Bob', 'Sales'), ('Carol', NULL)]

D[('Alice', 'HR'), ('Bob', 'Sales'), ('Carol', 'Finance')]

Step-by-Step Solution

Solution:

Step 1: Identify matching rows by dept_id
Employees with dept_id 10 and 20 match Departments with same dept_id. Carol's dept_id 30 has no match.
Step 2: Understand INNER JOIN output
INNER JOIN returns only rows with matching dept_id in both tables, so Carol is excluded.
Final Answer:
[('Alice', 'HR'), ('Bob', 'Sales')] -> Option A
Quick Check:
INNER JOIN excludes unmatched rows [OK]

Quick Trick: INNER JOIN excludes rows without matching keys [OK]

Common Mistakes:

MISTAKES

Including unmatched rows in result
Assuming NULL values appear for unmatched rows
Confusing INNER JOIN with LEFT JOIN behavior

Master "INNER JOIN" 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 the tables:

Step 1: Identify matching rows by dept_id

Step 2: Understand INNER JOIN output

Final Answer:

Quick Check:

Want More Practice?