Structure of the CUSTOMERS Table

question 44

Multiple Choice

Structure of the CUSTOMERS table
​
Structure of the ORDERS table
Structure of the ORDERITEMS table
Structure of the BOOKS table
-Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?​

• A) ​SELECT title FROM books NATURAL JOIN orderitems WHERE qty > 1;
• B) ​SELECT title FROM books JOIN orderitems WHERE qty > 1;
• C) ​SELECT title FROM books JOIN orderitems ON (isbn)JOIN orders ON (order#) WHERE qty>1;
• D) ​SELECT title FROM books JOIN orderitems USING(isbn);

---

Definitions:

Margin of Safety

The difference between actual sales and break-even sales, indicating the extent to which sales can drop before losses occur.

Variable Costs

Costs that vary directly with the level of production or volume of output.

Fixed Costs

Expenses that do not change in proportion to the level of production or sales activity within a certain range.

Plantwide Overhead Rate

A single rate used to allocate all of a plant's manufacturing overhead costs to its production activities based on a uniform cost-driver.