Solution:Step 1: Understand the requirementWe want rows common to both tables including all three columns.Step 2: Analyze optionsSELECT item_id, item_name, quantity FROM InventoryA INTERSECT SELECT item_id, item_name, quantity FROM InventoryB; uses INTERSECT on all three columns, which returns rows

[Solved] Given two tables:InventoryA:item_id | item_name | quantity1 | Chair | 52 | Table | 33 | Lamp | 7InventoryB:item_id | item_name | quantity3 | Lamp | 74 | Sofa | 2Which SQL query returns the common... | SQL

SQL - Set Operations

ASELECT item_id, item_name FROM InventoryA INTERSECT SELECT item_id, item_name FROM InventoryB;

BSELECT item_id, item_name, quantity FROM InventoryA INTERSECT SELECT item_id, item_name, quantity FROM InventoryB;

CSELECT * FROM InventoryA JOIN InventoryB ON InventoryA.item_id = InventoryB.item_id;

DSELECT item_id, item_name, quantity FROM InventoryA UNION SELECT item_id, item_name, quantity FROM InventoryB;

Step-by-Step Solution

Solution:

Step 1: Understand the requirement
We want rows common to both tables including all three columns.
Step 2: Analyze options
SELECT item_id, item_name, quantity FROM InventoryA INTERSECT SELECT item_id, item_name, quantity FROM InventoryB; uses INTERSECT on all three columns, which returns rows exactly matching in both tables.
Step 3: Evaluate other options
SELECT item_id, item_name FROM InventoryA INTERSECT SELECT item_id, item_name FROM InventoryB; excludes quantity, so it may return partial matches. SELECT * FROM InventoryA JOIN InventoryB ON InventoryA.item_id = InventoryB.item_id; is a JOIN, which returns combined rows but not necessarily identical rows. SELECT item_id, item_name, quantity FROM InventoryA UNION SELECT item_id, item_name, quantity FROM InventoryB; is UNION, which returns all rows from both tables.
Final Answer:
SELECT item_id, item_name, quantity FROM InventoryA INTERSECT SELECT item_id, item_name, quantity FROM InventoryB; -> Option B
Quick Check:
INTERSECT returns exact matching rows [OK]

Quick Trick: Use INTERSECT on all columns to find exact common rows [OK]

Common Mistakes:

MISTAKES

Using JOIN instead of INTERSECT for exact matches
Using UNION which combines all rows
Selecting fewer columns causing partial matches

Master "Set Operations" 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 two tables:

Step 1: Understand the requirement

Step 2: Analyze options

Step 3: Evaluate other options

Final Answer:

Quick Check:

Want More Practice?