Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS??
A. SELECT gift FROM promotion WHERE gift = minretail;
B. SELECT gift FROM promotion, books WHERE retail >= minretail AND title = 'SHORTEST POEMS';
C. SELECT gift FROM promotion, books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS';
D. none of the above
Answer: C. SELECT gift FROM promotion, books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS';
Business
You might also like to view...
Which of the following is a disadvantage of person-administered surveys?
A) They are slower than other methods. B) They are more expensive. C) They are prone to errors. D) High cost. E) all of the above
Business
The service analogy to the bill of materials in a manufacturing company is the bill of:
A) resources. B) services. C) sub-services. D) tender.
Business