Solution:Step 1: Identify right table rowsSales has SaleID 101 (ProductID 1) and 102 (ProductID 3).Step 2: Match Products to SalesProductID 1 matches Pen; ProductID 3 has no matching product, so Name is NULL.Final Answer:Pen | 101NULL | 102 -> Option CQuick Check:RIGHT JOIN keeps all sales, unmatch

[Solved] Consider tables:Products:ProductID | Name1 | Pen2 | PencilSales:SaleID | ProductID101 | 1102 | 3What is the output of:SELECT Products.Name, Sales.SaleID FROM Products RIGHT JOIN Sales ON Products.... | SQL

SQL - LEFT and RIGHT JOIN

APen | 101<br>Pencil | 102

BPen | 101<br>Pencil | NULL

CPen | 101<br>NULL | 102

DNULL | 101<br>NULL | 102

Step-by-Step Solution

Solution:

Step 1: Identify right table rows
Sales has SaleID 101 (ProductID 1) and 102 (ProductID 3).
Step 2: Match Products to Sales
ProductID 1 matches Pen; ProductID 3 has no matching product, so Name is NULL.
Final Answer:
Pen | 101
NULL | 102 -> Option C
Quick Check:
RIGHT JOIN keeps all sales, unmatched products NULL = Pen | 101
NULL | 102 [OK]

Quick Trick: RIGHT JOIN keeps all right rows, unmatched left columns NULL [OK]

Common Mistakes:

MISTAKES

Assuming unmatched right rows are excluded
Mixing up ProductID and SaleID
Expecting all products to appear

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: Identify right table rows

Step 2: Match Products to Sales

Final Answer:

Quick Check:

Want More Practice?