Solution:Step 1: Analyze WHERE clause effect on LEFT JOINWHERE s.quantity > 10 filters rows after the join. Unmatched products get NULL for quantity.Step 2: Understand filtering resultNULL > 10 is false, so unmatched excluded. Only matched rows with quantity > 10 remain: products with sales quantity

[Solved] Consider tables:Products(id, name)Sales(product_id, quantity)Query:SELECT p.name, s.quantity FROM Products p LEFT JOIN Sales s ON p.id = s.product_id WHERE s.quantity > 10;What will this query return? | SQL

SQL - LEFT and RIGHT JOIN

Consider tables:
Products(id, name)
Sales(product_id, quantity)
Query:
SELECT p.name, s.quantity FROM Products p LEFT JOIN Sales s ON p.id = s.product_id WHERE s.quantity > 10;
What will this query return?

ANo rows because WHERE filters out NULLs

BOnly products with sales quantity > 10

CAll products regardless of sales quantity

DAll products with NULL quantity replaced by 0

Step-by-Step Solution

Solution:

Step 1: Analyze WHERE clause effect on LEFT JOIN
WHERE s.quantity > 10 filters rows after the join. Unmatched products get NULL for quantity.
Step 2: Understand filtering result
NULL > 10 is false, so unmatched excluded. Only matched rows with quantity > 10 remain: products with sales quantity > 10.
Final Answer:
Only products with sales quantity > 10 -> Option B
Quick Check:
WHERE on right table column filters LEFT JOIN to matching rows satisfying condition [OK]

Quick Trick: WHERE on right table column after LEFT JOIN excludes unmatched and non-qualifying rows [OK]

Common Mistakes:

MISTAKES

Assuming all left rows appear despite WHERE
Thinking NULLs become 0 automatically
Confusing WHERE with ON clause filtering

Master "LEFT and RIGHT JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Consider tables:

Step 1: Analyze WHERE clause effect on LEFT JOIN

Step 2: Understand filtering result

Final Answer:

Quick Check:

Want More Practice?