Contents of the CUSTOMERS table

-Based upon the contents of the CUSTOMERS table, which of the following would be the most appropriate use of a subquery?
A) When searching for all customers who live in the same state as customer# 1007.
B) When searching for all customers who were referred by customer# 1003.
C) When searching for all customers with the last name of Thompson.
D) When searching for all customers assigned customer# 1010.

Question

Contents of the CUSTOMERS table
 
-Based upon the contents of the CUSTOMERS table, which of the following would be the most appropriate use of a subquery?
A) When searching for all customers who live in the same state as customer# 1007. 
B) When searching for all customers who were referred by customer# 1003. 
C) When searching for all customers with the last name of Thompson. 
D) When searching for all customers assigned customer# 1010.

Quizplus · Accepted Answer

A subquery is useful when you need to compare or match data from the same or another table. In this case, finding customers in the same state as customer# 1007 requires comparing the state of customer# 1007 with other customers, which is a suitable scenario for a subquery.

Contents of the CUSTOMERS Table