Match the Following SQL Keywords with Their Purposes

question 87

Essay

Match the following SQL keywords with their purposes:
I. SELECT
II. FROM
III. WHERE
IV. GROUP BY
V. ORDER BY
A. This is not a SQL keyword.
B. Specifies the sort order of the records
C. Specifies which table or tables contain the necessary fields
D. Specifies any criteria which will be applied to the records
E. Specifies which fields will be displayed

---

Definitions:

Net Income

The net income of a company once all costs, taxes, and expenses are deducted from the total revenue.

Personal Use

The use of an asset or product for individual rather than commercial or professional purposes.

Capital Contributions

Funds or assets contributed to a company by owners or shareholders, typically used to fund business operations or expansion.

Total Share

The aggregate number of shares that represents ownership in a company, including both common and preferred stock.