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);
c
You might also like to view...
The tort of disparagement:
A. covers true statements about the personal behavior of persons in business. B. does not include truth as a common defense. C. requires proof of actual damage. D. is identical to the tort of slander.
________ are a method of reviewing the manner in which internal and external customer needs are addressed.
A. Focus groups B. Ethical codes C. Churn rates D. Vision statements
Barry Corp reported 2016 net income of $40,000. However, the ending inventory in 2015 had been understated by $3,000, and 2016's ending inventory had been overstated by $6,000. Barry's correct net income for 2016 was
A) $31,000 B) $34,000 C) $43,000 D) $46,000
All of the data for the income statement are obtained from the Income Statement columns of the work sheet
Indicate whether the statement is true or false