Match the Following SQL Keywords with Their Purposes

question 60

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:

Check Register

A record of checks written, deposits made, and current balances within a checking account.

Deposits

Money placed into an account or given to a third party as a pledge for the fulfilment of an agreement.

Cash Balance

The amount of money in cash or cash equivalents that a company or individual has available at any given time.

Check Register

A record book or digital log used to track checks written, deposits made, and current balance of a checking account.