Contents of the ORDERS Table

question 9

Multiple Choice

Contents of the ORDERS table

-​Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will return all orders shipped within three days after the order was received?

• A) ​SELECT * FROM orders WHERE shipdate-orderdate >= 3;
• B) ​SELECT * FROM orders WHERE shipdate-orderdate =< 3;
• C) ​SELECT * FROM orders WHERE NOT shipdate-orderdate => 3;
• D) ​SELECT * FROM orders WHERE shipdate-orderdate <= 3;

---

Definitions:

Nonrival

A characteristic of a good or service where one person's use does not diminish its availability to others.

Marginal Cost

The increase in total production cost that arises from producing one additional unit of a good or service.

Public Good

A product or service that is provided without profit to all members of a society, either by the government or a private individual or organization.

Nonexcludable

A characteristic of a good where it is not possible to prevent individuals from accessing or consuming the good.