Multiple choice technology databases

A table has the following data: [[5, Null, 10]].What will the average function return ?

  1. Null

  2. 7.5

  3. 5

  4. 10
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The AVG function ignores NULL values and calculates the average of non-NULL values only. (5 + 10) / 2 = 7.5. It does not return NULL, 5, or 10.

Keep practicing — related questions