00:00

2500. Standardize Customer Contacts

EasySQLITE99 / 1584

Relevant companies

Amazon

Walmart

Target

Instacart

Shopify

eBay

Etsy

Wayfair

Chewy

Kroger

Costco

Best Buy

Home Depot

IKEA

Alibaba

Flipkart

Mercado Libre

Rakuten

Faire

Coupang

2500. Standardize Customer Contacts

Easy99 / 1584

Relevant companies

Amazon

Walmart

Target

Instacart

Shopify

eBay

Etsy

Wayfair

Chewy

Kroger

Costco

Best Buy

Home Depot

IKEA

Alibaba

Flipkart

Mercado Libre

Rakuten

Faire

Coupang

Sign in to Practice

Write SQL and Python, run instantly in your browser, and track your progress.

Runs live in your browser — no setup
Save progress across all 1,500+ problems
Submit and validate your answer instantly

Business Problem

You are a Data Analyst at Amazon. Your team is building a new customer data platform, and you've been tasked with migrating customer data from a recently acquired subsidiary. The initial data dump is messy. Inconsistent formatting in phone numbers and email addresses is causing major headaches: marketing emails are bouncing, customer service reps are dialing wrong numbers, and duplicate customer profiles are being created.

To prevent this data chaos, you need to write a SQL query to standardize the contact information from the customers table before the final import. Your query must produce a clean, standardized list of customers with lowercased emails, cleaned phone numbers containing only digits, and uppercased country codes, sorted alphabetically by email for easy review.

Schema: customers

Column Name	Type
customer_id	INTEGER
full_name

Business Problem

Schema: customers

Column Name	Type
customer_id	INTEGER
full_name

Standardize Customer Contacts — SQL Easy | Let's Data Science | Let's Data Science

customer_id	email_lower	phone_digits	country_upper
45	ahmed_collins@icloud.com	+12719915573	CA
46	anakamura@aol.com	+61252793925	AU
3	andrea_miller@zoho.com	+18034841106	CA
12	ann.o'connor96@hotmail.com	+15704243266

customer_id	email_lower	phone_digits	country_upper
45	ahmed_collins@icloud.com	+12719915573	CA
46	anakamura@aol.com	+61252793925	AU
3	andrea_miller@zoho.com	+18034841106	CA
12	ann.o'connor96@hotmail.com	+15704243266

2500. Standardize Customer Contacts

Relevant companies

Tags

2500. Standardize Customer Contacts

Relevant companies

Tags

Sign in to Practice