CODE EXAMPLE FOR SQL

postgresql isnull with max

SELECT coalesce(field, 'Empty') AS field_alias