COALESCE receives a list of scalars as arguments and returns the first value that is not NULL. If all scalars are NULL, then COALESCE returns NULL.