Multiple choice technology databases

How can we calculate average of a column?

  1. using AVG () function

  2. Using AVERAGE() function

  3. using SUM() and Count() functions

  4. using Total() function

Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

To calculate the average of a column, you can either use the built-in AVG() aggregate function directly or divide the sum of the values using SUM() by the count of the values using COUNT(). Both methods produce the correct average.