​ Contents of the PROMOTION Table

question 50

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