How to display in one row the Work email (if exists) or home email if the work email is null?
this function does not work
MAX(CASE
WHEN "Person Email Addresses"."Email Type Code"='W1'
THEN "Person Email Addresses"."Email Address"
WHEN "Person Email Addresses"."Email Type Code"='H1'
THEN "Person Email Addresses"."Email Address"
END by "Worker"."Person Number")
