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

B, E, A, C, D

Computer Science & Information Technology

You might also like to view...

A(n) ________ is a database object that you create and use independently of other controls or objects

A) stand-alone macro B) procedure macro C) embedded macro D) command macro

Computer Science & Information Technology

The owner of a file or folder may deny Administrators access to a resource. But an administrator can exercisethe optional right to take ________of any resource to gain access to it

Fill in the blank(s) with correct word

Computer Science & Information Technology