Which statement is true regarding the COALESCE function?()
- AIt can have a maximum of five expressions in a list
- BIt returns the highest NOT NULL value in the list for all rows
- CIt requires that all expressions in the list must be of the same data type
- DIt requires that at least one of the expressions in the list must have a NOT NULL value