How to Use PostgreSQL COALESCE effectively with examples

How to Use PostgreSQL COALESCE effectively with examples