Match each aggregate function with the value it returns:
I. Avg
II. Count
III. Maximum
IV. Minimum
V. Sum
A. Returns the data item with the highest value
B. Returns the data item with the lowest value
C. Returns the mean value of a group of numbers
D. Returns the total value of a column of numbers
E. Returns the number of fields containing data
Correct Answer:
Verified
Q54: Aggregate functions perform calculations on an entire
Q62: The MAXIMUM aggregate function can work with
Q66: The SUM aggregate function can work with
Q68: Match each mathematical symbols to the operation
Q69: Match each element of an expression with
Q70: The present_value argument of the Pmt Function
Q71: Match the following terms to their meanings:
I.
Q73: A query with a Total row is
Q78: It is NOT possible to add a
Q79: A Total row displays the results of
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents