Check out example codes for "postgresql isnull with max". It will help you in understanding the concepts better.

Code Example 1

SELECT coalesce(field, 'Empty') AS field_alias

Learn ReactJs, React Native from akashmittal.com