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

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 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

Quizplus · Accepted Answer

The correct SQL statement to display the gift for a customer who orders a specific book based on a retail price range condition is not accurately represented in any of the provided options. Options A, B, and C either do not correctly link the tables based on a specific book title or misuse SQL syntax, particularly in how they attempt to apply conditions or join tables.

​ Contents of the PROMOTION Table

Contents of the PROMOTION Table