​ Contents of the PROMOTION Table

question 30

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

---

Definitions:

Production Orders

Instructions for manufacturing a certain number of products, detailing the materials, components, and assembly or production processes required.

Activity-Based Costing

A costing method that assigns overhead and indirect costs to specific activities based on their use or consumption.

Activity-Based Costing

A method of costing that identifies specific activities within an organization and assigns costs to those activities based on their use of resources.

Activity-Based Costing

A costing method that assigns costs to products and services based on the resources they consume.