​ Contents of the PROMOTION Table

Multiple Choice

​
Contents of the PROMOTION table
Structure of the BOOKS table
-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