Match the Following Aggregate Functions with What They Compute

question 5

Essay

Match the following aggregate functions with what they compute:
I. Avg
II. Sum
III. Count
IV. Min
V. Max
A. Counts the number of values in a column
B. Average of a column
C. Returns the lowest value
D. Returns the highest value
E. Totals the items in a column

---

Definitions:

Average Prevalence

The typical rate or extent to which a particular disease or condition is found in a population over a specific time period.

Theorist

An individual who proposes, develops, or supports theories in a particular field of study.

Symptoms

Physical or mental features that are regarded as indicating a condition of disease, particularly such features that are apparent to the patient.

Family Members

Individuals related by blood, marriage, or adoption, who may share a living space and have significant emotional and economic ties to one another.