How to Replicate the Substitute Function in Excel Using Presto SQL

Using Common Table Expressions in SQL Queries: Avoiding COALESCE Data Type Incompatibility