Solution:Step 1: Understand the requirementWe want sales in 2022 that are not in 2023.Step 2: Use EXCEPT correctlyEXCEPT returns rows from the first query that are not in the second. So, selecting from sales_2022 EXCEPT sales_2023 is correct.Step 3: Analyze optionsSELECT sale_id FROM sales_2022 EXCE

[Solved] Given two tables:sales_2022:sale_id10203040sales_2023:sale_id30405060Which query correctly finds sales from 2022 that did not occur in 2023 using EXCEPT? | SQL

SQL - Set Operations

Given two tables:
sales_2022:
sale_id
10
20
30
40

sales_2023:
sale_id
30
40
50
60

Which query correctly finds sales from 2022 that did not occur in 2023 using EXCEPT?

ASELECT sale_id FROM sales_2022 INTERSECT SELECT sale_id FROM sales_2023;

BSELECT sale_id FROM sales_2023 EXCEPT SELECT sale_id FROM sales_2022;

CSELECT sale_id FROM sales_2022 EXCEPT SELECT sale_id FROM sales_2023;

DSELECT sale_id FROM sales_2022 UNION SELECT sale_id FROM sales_2023;

Step-by-Step Solution

Solution:

Step 1: Understand the requirement
We want sales in 2022 that are not in 2023.
Step 2: Use EXCEPT correctly
EXCEPT returns rows from the first query that are not in the second. So, selecting from sales_2022 EXCEPT sales_2023 is correct.
Step 3: Analyze options
SELECT sale_id FROM sales_2022 EXCEPT SELECT sale_id FROM sales_2023; matches the requirement. SELECT sale_id FROM sales_2023 EXCEPT SELECT sale_id FROM sales_2022; reverses the order, giving sales in 2023 not in 2022. SELECT sale_id FROM sales_2022 INTERSECT SELECT sale_id FROM sales_2023; returns common sales. SELECT sale_id FROM sales_2022 UNION SELECT sale_id FROM sales_2023; returns all sales combined.
Final Answer:
SELECT sale_id FROM sales_2022 EXCEPT SELECT sale_id FROM sales_2023; -> Option C
Quick Check:
First table EXCEPT second table returns unique rows in first [OK]

Quick Trick: EXCEPT returns rows unique to first query's result [OK]

Common Mistakes:

MISTAKES

Swapping the order of tables in EXCEPT
Using INTERSECT instead of EXCEPT
Using UNION which combines all rows

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: Use EXCEPT correctly

Step 3: Analyze options

Final Answer:

Quick Check:

Want More Practice?