https://www.enterprisedb.com/postgres-tutorials/how-use-coalesce-postgresql
How to use COALESCE in PostgreSQL | EDB
In this post, we are going to understand what the COALESCE function is and how to use it in PostgreSQL.
how to use coalescepostgresqledb