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

Question

​
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

Quizplus · Accepted Answer

Option A does not include the book titled SHORTEST POEMS and does not specify the table where the minretail value should be derived from. 
Option B uses a JOIN syntax that links the PROMOTION and BOOKS tables, but the condition specified in the WHERE clause is flawed. It should be to check if books.title = 'SHORTEST POEMS' AND books.retail >= promotion.minretail instead.
Option C uses the correct JOIN syntax and checks if the book titled SHORTEST POEMS falls under the retail price range specified in the PROMOTION table. This would give the gift that should be sent to the customer who orders this book.

​ Contents of the PROMOTION Table

Contents of the PROMOTION Table