Which aggregate function calculates the average value?

Which aggregate function calculates the average value?

• A. SUM
• B. AVG
• C. MAX
• D. MIN

Answer: (B)

This question tests how to compute the average of a set of values using an aggregate function. The function that returns the mean is AVG. It takes a numeric column and computes the arithmetic average, usually ignoring NULLs. For example, values 2, 4, and 6 give AVG as (2 + 4 + 6) / 3 = 4. This differs from SUM, which adds all values; MAX, which finds the largest value; and MIN, which finds the smallest. So AVG is the correct choice for calculating the average value.

This question tests how to compute the average of a set of values using an aggregate function. The function that returns the mean is AVG. It takes a numeric column and computes the arithmetic average, usually ignoring NULLs. For example, values 2, 4, and 6 give AVG as (2 + 4 + 6) / 3 = 4. This differs from SUM, which adds all values; MAX, which finds the largest value; and MIN, which finds the smallest. So AVG is the correct choice for calculating the average value.