Solution:Step 1: Select product column from both tablesWe want unique products, so select only the product column from both tables.Step 2: Use UNION to combine and remove duplicatesUNION combines both lists and removes duplicates, giving unique products.Step 3: Sort results alphabeticallyORDER BY pr

[Solved] You have two tables:Sales2023(product, amount)Apple, 100Banana, 150Sales2024(product, amount)Banana, 200Cherry, 300Write a query using UNION to list all unique products sold in both years, sorted... | SQL

SQL - Set Operations

You have two tables:

Sales2023(product, amount)
Apple, 100
Banana, 150

Sales2024(product, amount)
Banana, 200
Cherry, 300

Write a query using UNION to list all unique products sold in both years, sorted alphabetically.

ASELECT product, amount FROM Sales2023 UNION SELECT product, amount FROM Sales2024 ORDER BY amount;

BSELECT product FROM Sales2023 UNION ALL SELECT product FROM Sales2024 ORDER BY product;

CSELECT product FROM Sales2023 UNION SELECT product FROM Sales2024 ORDER BY product;

DSELECT product FROM Sales2023 JOIN Sales2024 ON product ORDER BY product;

Step-by-Step Solution

Solution:

Step 1: Select product column from both tables
We want unique products, so select only the product column from both tables.
Step 2: Use UNION to combine and remove duplicates
UNION combines both lists and removes duplicates, giving unique products.
Step 3: Sort results alphabetically
ORDER BY product sorts the final list alphabetically.
Final Answer:
SELECT product FROM Sales2023 UNION SELECT product FROM Sales2024 ORDER BY product; -> Option C
Quick Check:
UNION + ORDER BY product = B [OK]

Quick Trick: Use UNION to remove duplicates, ORDER BY to sort [OK]

Common Mistakes:

MISTAKES

Using UNION ALL which keeps duplicates
Selecting amount column when only product needed
Using JOIN instead of UNION

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: Select product column from both tables

Step 2: Use UNION to combine and remove duplicates

Step 3: Sort results alphabetically

Final Answer:

Quick Check:

Want More Practice?