Solution:Step 1: Match Employees.DeptID with Departments.DeptIDEmployees have DeptIDs 10, 20, 30; Departments have 10, 20, 40.Step 2: Find matching DeptIDsMatches are 10 and 20 only; 30 (Carol) has no matching department.Final Answer:[('Alice', 'Sales'), ('Bob', 'HR')] -> Option AQuick Check:INNER

[Solved] Given these tables:EmployeesID | Name | DeptID1 | Alice | 102 | Bob | 203 | Carol | 30DepartmentsDeptID | DeptName10 | Sales20 | HR40 | ITWhat is the result of this query?SELECT Employees.... | SQL

SQL - INNER JOIN

SELECT Employees.Name, Departments.DeptName FROM Employees INNER JOIN Departments ON Employees.DeptID = Departments.DeptID;

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

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

C[('Alice', 'Sales'), ('Carol', 'IT')]

D[('Bob', 'HR'), ('Carol', 'IT')]

Step-by-Step Solution

Solution:

Step 1: Match Employees.DeptID with Departments.DeptID
Employees have DeptIDs 10, 20, 30; Departments have 10, 20, 40.
Step 2: Find matching DeptIDs
Matches are 10 and 20 only; 30 (Carol) has no matching department.
Final Answer:
[('Alice', 'Sales'), ('Bob', 'HR')] -> Option A
Quick Check:
INNER JOIN returns only matching DeptIDs [OK]

Quick Trick: Only rows with matching DeptID appear in INNER JOIN result [OK]

Common Mistakes:

MISTAKES

Including unmatched rows like Carol's
Confusing DeptID with ID
Assuming all departments join

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 these tables:

Step 1: Match Employees.DeptID with Departments.DeptID

Step 2: Find matching DeptIDs

Final Answer:

Quick Check:

Want More Practice?