Solution:Step 1: Identify columns to compareYou want to compare only product_id and name, ignoring price differences.Step 2: Use INTERSECT on matching columnsSELECT product_id, name FROM ProductsA INTERSECT SELECT product_id, name FROM ProductsB; selects product_id and name from both tables and inte

[Solved] You have two tables:ProductsA with columns product_id, name, priceProductsB with columns product_id, name, priceYou want to find products that exist in both tables with the same product_id and name,... | SQL

SQL - Set Operations

You have two tables:
ProductsA with columns product_id, name, price
ProductsB with columns product_id, name, price

You want to find products that exist in both tables with the same product_id and name, ignoring price differences.

Which query correctly uses INTERSECT to achieve this?

ASELECT product_id, name, price FROM ProductsA INTERSECT SELECT product_id, name, price FROM ProductsB;

BSELECT product_id, name FROM ProductsA INTERSECT SELECT product_id, name FROM ProductsB;

CSELECT product_id FROM ProductsA INTERSECT SELECT product_id FROM ProductsB;

DSELECT * FROM ProductsA INTERSECT SELECT * FROM ProductsB;

Step-by-Step Solution

Solution:

Step 1: Identify columns to compare
You want to compare only product_id and name, ignoring price differences.
Step 2: Use INTERSECT on matching columns
SELECT product_id, name FROM ProductsA INTERSECT SELECT product_id, name FROM ProductsB; selects product_id and name from both tables and intersects them, returning only products common by those two columns.
Step 3: Analyze other options
SELECT product_id, name, price FROM ProductsA INTERSECT SELECT product_id, name, price FROM ProductsB; includes price, so products with different prices won't match. SELECT product_id FROM ProductsA INTERSECT SELECT product_id FROM ProductsB; compares only product_id, ignoring name. SELECT * FROM ProductsA INTERSECT SELECT * FROM ProductsB; compares all columns, including price, which is not desired.
Final Answer:
SELECT product_id, name FROM ProductsA INTERSECT SELECT product_id, name FROM ProductsB; -> Option B
Quick Check:
INTERSECT on selected columns matches desired fields [OK]

Quick Trick: Select only columns to compare before INTERSECT [OK]

Common Mistakes:

MISTAKES

Including extra columns that cause mismatches
Selecting * when columns differ
Comparing only one column when two are needed

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

You have two tables:

Step 1: Identify columns to compare

Step 2: Use INTERSECT on matching columns

Step 3: Analyze other options

Final Answer:

Quick Check:

Want More Practice?