Column A of a relation has the following list of values in the six rows of the table:
NULL, NULL, 10, 10, 20, 30
In SQL Server, which of the following is the correct value of
AVG(DISTINCT A)?
a. 15
b. NULL
c. 20
d. 10
Answer: C
Column A of a relation has the following list of values in the six rows of the table:
NULL, NULL, 10, 10, 20, 30
In SQL Server, which of the following is the correct value of
AVG(DISTINCT A)?
a. 15
b. NULL
c. 20
d. 10
Answer: C