Structure of the CUSTOMERS Table

question 5

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 the books ordered by customer# 1003?​

• A) ​SELECT title FROM customers NATURAL JOIN books WHERE customer# = 1003;
• B) ​SELECT title FROM customers JOIN orders USING (customer#) JOIN orderitems USING (order#)JOIN books USING (isbn) WHERE customer# = 1003;
• C) ​SELECT title FROM customers JOIN orders ON (customer#) JOIN orderitems ON (order#)JOIN books ON (isbn) WHERE customer# = 1003;
• D) ​both a and b

---

Definitions:

Average Accounting Return

A measure of the profitability of an investment, calculated as the average annual net income divided by the average investment.

Time Value

The concept in finance that money available at the present time is worth more than the same amount in the future due to its potential earning capacity.

Calculation

The process of determining a numerical result based on mathematical operations or algorithms.

Average Accounting Return

A financial ratio that measures the average net income that a firm generates as a percentage of its average book value of equity.