Contents of the CUSTOMERS Table​

Multiple Choice

Contents of the CUSTOMERS table​

-​Based on the contents of the CUSTOMERS table,which SQL statement will display the customers residing in the same state as customer#1013?

A) ​SELECT customer# FROM customers WHERE customer# =
(SELECT state FROM customers WHERE state = 'NJ') ;
B) ​SELECT customer# FROM customers WHERE state =
(SELECT state FROM customers WHERE customer#=1013) ;
C) ​SELECT customer# FROM customers WHERE customer# IN
(SELECT state FROM customers WHERE state = 'NJ') ;
D) ​SELECT customer# FROM customers WHERE state EXISTS
(SELECT state FROM customers WHERE customer#=1013) ;