​ Structure of the ORDERS Table

question 36

Multiple Choice

​
Structure of the ORDERS table
Structure of the CUSTOMERS table
​
-Which of the following SQL statements will display all customers who have not recently placed an order?​

• A) ​SELECT customer# FROM customers UNION SELECT customer# FROM orders;
• B) ​SELECT customer# FROM orders MINUS SELECT customer# FROM customers;
• C) ​SELECT customer# FROM orders INTERSECT SELECT customer# FROM customers;
• D) ​SELECT customer# FROM customers MINUS SELECT customer# FROM orders;

---

Definitions:

Average Fixed Cost

The fixed costs of production (costs that do not change with the level of output) divided by the quantity of output produced, decreasing as production increases.

Short Run

A period during which at least one factor of production is fixed, affecting a firm's ability to adjust to market changes.

Hold-Up Problems

Situations where one party in a negotiation exploits their bargaining advantage at the expense of others, often after a mutual investment or commitment is made.

Equipment Specific

Pertaining to or designed for particular pieces of equipment, often implying specialized usage or requirements.