​Contents of ORDERS Table

question 53

Multiple Choice

​Contents of ORDERS table
Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
-​Based upon the contents of the ORDERS table,which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

• A) SELECT order#,SUBSTR(shipzip,1,323) FROM orders;
• B) SELECT order#,SUBSTR(shipzip,1,323) FROM orders WHERE shipzip = 323;
• C) SELECT order# FROM orders WHERE shipzip = SUBSTR(shipzip,1,323);
• D) SELECT order# FROM orders WHERE SUBSTR(shipzip,1,3)= 323;

---

Definitions:

Corporate Profits

The earnings of a corporation after all expenses, taxes, and costs have been deducted from total revenue.

Consumer Preferences

The subjective tastes and desires influencing the choices that consumers make among various products and services.

Occupational Safety and Health Act

A law enacted to ensure safe and healthful working conditions for employees by setting and enforcing standards and providing training, outreach, education, and assistance.

Securities Act

A U.S. law enacted in 1933 that requires transparency in the sale of securities to protect investors from fraud and misleading information.