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...