Solution:Step 1: Identify columns to combineWe want product_name and price/amount columns from both tables.Step 2: Check column counts and typesSELECT product_name, price FROM Products UNION SELECT product_name, amount FROM Sales; selects two columns from each table with compatible types (VARCHAR an

[Solved] You have two tables:Table Products:product_id INT, product_name VARCHAR, price DECIMALTable Sales:sale_id INT, product_name VARCHAR, amount DECIMALYou want to combine product_name and price/amount... | SQL

SQL - Set Operations

You have two tables:

Table Products:
product_id INT, product_name VARCHAR, price DECIMAL

Table Sales:
sale_id INT, product_name VARCHAR, amount DECIMAL

You want to combine product_name and price/amount columns from both tables using UNION. Which query is correct?

ASELECT product_name, price FROM Products UNION SELECT sale_id, amount FROM Sales;

BSELECT product_id, product_name FROM Products UNION SELECT sale_id, product_name FROM Sales;

CSELECT product_name, price FROM Products UNION SELECT product_name FROM Sales;

DSELECT product_name, price FROM Products UNION SELECT product_name, amount FROM Sales;

Step-by-Step Solution

Solution:

Step 1: Identify columns to combine
We want product_name and price/amount columns from both tables.
Step 2: Check column counts and types
SELECT product_name, price FROM Products UNION SELECT product_name, amount FROM Sales; selects two columns from each table with compatible types (VARCHAR and DECIMAL).
Final Answer:
SELECT product_name, price FROM Products UNION SELECT product_name, amount FROM Sales; -> Option D
Quick Check:
Matching columns and types = C [OK]

Quick Trick: UNION columns must match in count and compatible types [OK]

Common Mistakes:

MISTAKES

Mixing unrelated columns
Mismatching column counts
Ignoring data type compatibility

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 combine

Step 2: Check column counts and types

Final Answer:

Quick Check:

Want More Practice?