Which statement is true regarding the COALESCE function?
A.
It requires that at least one of the expressions in the list must have a NOT NULL value.
B.
It can have a maximum of five expressions in a list.
C.
It returns the highest NOT NULL value in the list for all rows.
D.
It requires that all expressions in the list must be of the same data type.