The SQL Aggregate Function That Gives the Number of Rows

question 19

Multiple Choice

The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.

• A) COUNT
• B) MIN
• C) MAX
• D) SUM

---

Definitions:

Quarterly Payment

Payments made every three months in a year, often used for loans, subscriptions, or service contracts.

Preferred Share

A class of ownership in a corporation that has a higher claim on its assets and earnings than common shares, typically with fixed dividends.

Compounded

The process where the value of an investment increases due to the interest earned on both the principal and the accumulated interest.

Semi-annually

refers to occurrences that happen twice a year.