Could you help me write the ELSE statement when nothing fits the above conditions? I just want it take whatever the current value is.
CASE
WHEN (Country IS NULL AND (NAME like '% US %' OR NAME like '%US-%')) THEN "US"
WHEN (Country IS NULL AND (NAME like '% CA %' OR NAME like ' 