00:00

1001. US Customers With Missing Phone

EasySQLITE2 / 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

1001. US Customers With Missing Phone

Easy2 / 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 Walmart. The product team is planning to launch a new feature that sends SMS notifications for order updates and promotions. To understand the potential reach of this feature, they first need to identify US-based customers whose phone numbers are missing from the database. A clean dataset is crucial before launching the campaign.

Your task is to generate a list of all customers in the 'US' for whom a phone number is missing (NULL), but a state is on file (indicating the account has some location data). The list should include the customer's ID, full name, email, and state, sorted alphabetically by the customer's full name.

Schema: customers

Column Name	Type
customer_id

Business Problem

Schema: customers

Column Name	Type
customer_id

full_name

US Customers With Missing Phone — SQL Easy | Let's Data Science | Let's Data Science

customer_id	full_name	email	state
15	Chen Mendoza	chen_mendoza@yahoo.com	NC
11	Denise Huang	deniseh@aol.com	TX
49	Douglas Moore	douglas.moore@protonmail.com	OH
25	Douglas Price	douglas.price@aol.com

customer_id	full_name	email	state
15	Chen Mendoza	chen_mendoza@yahoo.com	NC
11	Denise Huang	deniseh@aol.com	TX
49	Douglas Moore	douglas.moore@protonmail.com	OH
25	Douglas Price	douglas.price@aol.com

1001. US Customers With Missing Phone

Relevant companies

Tags

1001. US Customers With Missing Phone

Relevant companies

Tags

Sign in to Practice