Contents of the CUSTOMERS Table​

Multiple Choice

Contents of the CUSTOMERS table​

-​Based on the contents of the CUSTOMERS table,which of the following SQL statements will display the customer# of all customers who were referred by the same individual that referred customer# 1003?

A) ​SELECT customer# FROM customers WHERE referred =
(SELECT referred FROM customers WHERE customer# = 1003) ;
B) ​SELECT customer# FROM customers WHERE referred EXISTS
(SELECT referred FROM customers WHERE customer# = 1003) ;
C) ​SELECT customer# FROM customers WHERE NVL(referred,0) =
(SELECT NVL(referred,0) FROM customers WHERE customer# = 1003) ;
D) ​SELECT customer# FROM customers WHERE NVL(referred,0) =
(SELECT referred FROM customers WHERE customer# = 1003) ;