Adding a ORDER BY UNIT_PRICE Clause to a SQL Query

question 20

Multiple Choice

Adding a ORDER BY UNIT_PRICE clause to a SQL query will _____.

• A) display the results in ascending order by UNIT_PRICE
• B) set UNIT_PRICE as the primary key for the table being queried
• C) display the results in descending order by UNIT_PRICE
• D) display UNIT_PRICE as the first column in the results

---

Definitions:

Consumer Price Index

An index that measures changes in the price level of a market basket of consumer goods and services purchased by households, often used as a measure of inflation.

Inflation-Adjusted

Refers to figures or financial metrics that have been altered to reflect inflation's effects, presenting a more accurate picture of real value or purchasing power.

Money Market

A segment of the financial market in which financial instruments with high liquidity and very short maturities are traded.

Subsector

A specific part of a larger sector or industry, categorized by similar business activities or products.