What is the output of the following query? SELECT COALESCE(NULL, NULL, 3, NULL, 5)

Question

SQL Fundamentals — Hard

Accepted Answer

The COALESCE function returns the first non-NULL value in the list. In this case, the first non-NULL value is 3, so the output of the query is 3.