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

Net Income

The total profit of a company after all expenses, including taxes and interest, have been deducted from total revenue; also known as net earnings or net profit.

Net Present Value

A method used in capital budgeting to evaluate the profitability of an investment by calculating the difference between the present value of cash inflows and outflows.

Internal Rate of Return

A metric used in capital budgeting to estimate the profitability of potential investments, calculated as the discount rate that makes the net present value of all cash flows from a particular project equal to zero.

Time Value

The principle that money currently in hand is valued higher than an identical amount received in the future, owing to its capacity to generate earnings.