Handle Inconsistent Formatting Across Sources

How would you analyze a dataset with inconsistent formatting across multiple sources?

Using the source_records table, write a query that standardizes customer names, region values, and amount text while excluding records without a customer name. Preserve valid negative, zero, and missing amount values.

Output

1. One row per retained source record, ordered by record_id ascending.
2. Return record_id, source_system, customer_name, region, and amount using those exact names.
3. Standardized names should use title case, regions should use uppercase, and amounts should be numeric or NULL.