A. Returns the first non-null expression among its arguments
B. Concatenates rows into a single string based on a specified condition
C. Calculates the average value of numeric column values
D. Retrieves the maximum value among the specified expressions

Solution

A. Returns the first non-null expression among its arguments