coalesce function

Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.