In the context of a Databricks Lakehouse architecture, you are working with silver-level data that has been aggregated from various bronze tables. You notice inconsistencies in customer names due to variations in casing and spacing (e.g., 'John Doe', 'john doe', 'John Doe'). What would be an appropriate SQL statement to standardize these customer names in the silver table CustomerData ?