Multiple choice technology databases

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

  1. 10

  2. 5.5

  3. 5

  4. 7.5
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The average function in SQL aggregate queries ignores NULL values. For the data set 5 and 10, the sum is 15 and the count of non-null values is 2, resulting in an average of 7.5.

Keep practicing — related questions