​ 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 THE WOK WAY TO COOK?​

A) SELECT title FROM promotion
WHERE retail BETWEEN minretail AND maxretail;
B) SELECT title FROM promotion NATURAL JOIN books
WHERE retail BETWEEN minretail AND maxretail;
C) SELECT title FROM promotion JOIN books
USING retail BETWEEN minretail AND maxretail;
D) ​none of the above