In Which of the Following Situations Would One Have to Use

question 91

Multiple Choice

In which of the following situations would one have to use an outer join in order to obtain the desired results?

• A) A report is desired that lists all customers who placed an order.
• B) A report is desired that lists all customers and the total of their orders.
• C) A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).
• D) There is never a situation that requires only an outer join.

---

Definitions:

Producer Surplus

The difference in earnings expected by producers for a good or service versus the actual payment received.

Equilibrium Price

The price at which the quantity of a good or service demanded by consumers is equal to the quantity supplied by producers, resulting in a balance without excess supply or demand.

Producer Surplus

The variance between the price producers want to sell an item for and the price they end up receiving.

Equilibrium Price

The price point at which the quantity of a good or service supplied equals the quantity demanded.