Solution:Step 1: Identify subquery outputThe subquery returns customer_id values for customers in New York.Step 2: Filter orders by customer_idThe main query selects order_id where customer_id matches any from the subquery.Final Answer:Order IDs placed by customers from New York -> Option BQuick Che

[Solved] Consider tables:Orders(order_id, customer_id, amount)Customers(customer_id, city)What is the output of this query?... | SQL

SQL - Subqueries

Consider tables:
Orders(order_id, customer_id, amount)
Customers(customer_id, city)
What is the output of this query?

SELECT order_id FROM Orders WHERE customer_id IN (SELECT customer_id FROM Customers WHERE city = 'New York');

AOrder IDs placed by customers not from New York

BOrder IDs placed by customers from New York

CAll order IDs regardless of customer city

DCustomer IDs from New York

Step-by-Step Solution

Solution:

Step 1: Identify subquery output
The subquery returns customer_id values for customers in New York.
Step 2: Filter orders by customer_id
The main query selects order_id where customer_id matches any from the subquery.
Final Answer:
Order IDs placed by customers from New York -> Option B
Quick Check:
IN filters orders by New York customers [OK]

Quick Trick: IN filters main query by subquery results [OK]

Common Mistakes:

MISTAKES

Mixing up order_id and customer_id
Assuming it returns all orders
Confusing city filter location

Master "Subqueries" 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 subquery output

Step 2: Filter orders by customer_id

Final Answer:

Quick Check:

Want More Practice?