REPLACE and CONCAT for Data Cleaning
Medium
string-functions
Amazon
Robinhood
Instacart
Write a query to clean phone numbers by removing dashes and parentheses, then format them as a display string with the customer name. Return name and clean_phone (just digits), ordered by name.
Expected Output: Customers with cleaned phone numbers.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...