Structure of the ORDERS Table

question 70

Multiple Choice

Structure of the ORDERS table

Structure of the CUSTOMERS table
-Which of the following SQL statements will list the name of each customer stored in the CUSTOMERS table, and, if the customer has placed an order that is contained in the ORDERS table, the order# of any order each customer has placed?

• A) SELECT lastname, firstname, order# FROM customers NATURAL JOIN orders;
• B) SELECT lastname, firstname, order# FROM customers c LEFT OUTER JOIN orders o ON
• C) SELECT lastname, firstname, order# FROM customers RIGHT OUTER JOIN orders;
• D)customer# = o.customer#;
• E) SELECT lastname, firstname, order# FROM customers JOIN orders USING (customer#);

---

Definitions:

Loyal

The quality of being faithful or devoted to a person, country, group, or cause.

Stockholders

Individuals or entities that own shares of stock in a corporation, making them partial owners of the company.

Marginal Efficiency

The rate of return on an investment that is additional or marginal to the current level of investment.

Capital

Assets or resources, such as machinery, buildings, or money, that can be used to produce goods and services and generate wealth.