​ 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

---

Definitions:

Indirect Materials

Materials used in the production process that cannot be directly linked to a specific product, such as lubricants and cleaning supplies.

Managerial Accounting

The practice of identifying, measuring, analyzing, interpreting, and communicating financial information to managers for the purpose of achieving organizational goals.

Decision Makers

Individuals or groups responsible for making choices or decisions within an organization, typically affecting its strategy or operations.

Plant Manager's Salary

A fixed cost representing the compensation paid to the individual responsible for overseeing the operations of a manufacturing facility.