[Solved] Given tables orders(order_id, customer_id, amount) and customers(customer_id, name), what will this query return?SELECT order_id, (SELECT name FROM customers WHERE customers.customer_id = orders.... | SQL

SQL - Subqueries

Given tables orders(order_id, customer_id, amount) and customers(customer_id, name), what will this query return?

SELECT order_id, (SELECT name FROM customers WHERE customers.customer_id = orders.customer_id) AS customer_name FROM orders;

AList of orders with NULL customer names

BError due to subquery returning multiple rows

CList of orders with corresponding customer names

DList of customers with their order counts

Step-by-Step Solution

Solution:

Step 1: Analyze subquery role
The subquery fetches the customer name matching each order's customer_id.
Step 2: Understand output
For each order, the scalar subquery returns one customer name, so the query lists orders with names.
Final Answer:
List of orders with corresponding customer names -> Option C
Quick Check:
Scalar subquery returns matching customer name [OK]

Quick Trick: Scalar subquery fetches one matching value per row [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given tables orders(order_id, customer_id, amount) and customers(customer_id, name), what will this query return?