[Solved] Consider these tables:Products(product_id, name)Sales(product_id, quantity)What does this query return?SELECT Products.name, Sales.quantity FROM Products INNER JOIN Sales ON Products.... | SQL

SQL - INNER JOIN

Consider these tables:
Products(product_id, name)
Sales(product_id, quantity)
What does this query return?

SELECT Products.name, Sales.quantity FROM Products INNER JOIN Sales ON Products.product_id = Sales.product_id WHERE Sales.quantity > 10;

AAll sales including products not sold

BAll products regardless of sales quantity

CSales with quantity less than or equal to 10

DProducts sold with quantity greater than 10

Step-by-Step Solution

Solution:

Step 1: Analyze INNER JOIN and WHERE clause
INNER JOIN matches products with sales by product_id; WHERE filters sales with quantity > 10.
Step 2: Interpret result
Only products with sales quantity greater than 10 appear, matching Products sold with quantity greater than 10. Others describe incorrect or unrelated results.
Final Answer:
Products sold with quantity greater than 10 -> Option D
Quick Check:
INNER JOIN + WHERE filters matching rows [OK]

Quick Trick: WHERE filters after INNER JOIN matches rows [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider these tables: