How to Replicate the Substitute Function in Excel Using Presto SQL

Merging Two Tables with a Union on All Values in a Single Column Using Full Outer Join and COALESCE Function in Amazon Athena (Presto)