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

Question

Quizplus · Accepted Answer

i. Avg computes the average of a column.  II. Sum totals the items in a column.  III. Count counts the number of values in a column.  IV. Min returns the lowest value.  v. Max returns the highest value.

Match the Following Aggregate Functions with What They Compute