Given tables Orders and Customers with columns Orders.CustomerID, Customers.ID, and Customers.Region, what will the following query return?

medium📝 query result Q4 of 15

SQL - INNER JOIN

Given tables Orders and Customers with columns Orders.CustomerID, Customers.ID, and Customers.Region, what will the following query return?

SELECT Orders.OrderID, Customers.Name FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.ID AND Customers.Region = 'West';

AOrders with customers from any region

BAll orders regardless of customer region

COrders with customers only from the West region

DOrders with customers only from the East region

Step-by-Step Solution

Solution:

Step 1: Analyze join conditions
The join matches Orders.CustomerID to Customers.ID and filters Customers.Region to 'West'.
Step 2: Understand result filtering
Only orders with customers in the West region will appear.
Final Answer:
Orders with customers only from the West region -> Option C
Quick Check:
Join filters by region = West only [OK]

Quick Trick: Join conditions can filter rows by column values [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes