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.ml
D) When searching for all customers assigned customer# 1010.html ml

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.ml> > 
D) ​When searching for all customers assigned customer# 1010.html> ml> >

Quizplus · Accepted Answer

Using a subquery to search for all customers who live in the same state as a specific customer (#1007) requires comparing data in two different tables (CUSTOMERS and CUSTOMER_ADDRESS), which makes it the most appropriate use of a subquery. Options B, C, and D only require searching for data within one table.

Contents of the CUSTOMERS Table​

Contents of the CUSTOMERS Table