00:00

2606. Customers with Orders but No Captured Payments

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

2606. Customers with Orders but No Captured Payments

Hard117 / 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 Payments Risk Analyst at Shopify. The Finance and Risk teams are investigating payment failures to identify customers who may be experiencing payment issues or attempting fraudulent orders. These customers have placed orders but none of their payments have been successfully captured, which could indicate declined cards, insufficient funds, or potential fraud attempts.

Your task is to identify all customers who have placed at least one order but have never had a payment successfully captured. This will help the team reach out to legitimate customers experiencing payment problems while flagging potentially fraudulent accounts.

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id

Business Problem

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id

Customers with Orders but No Captured Payments — SQL Hard | Let's Data Science | Let's Data Science

order_id	order_number	customer_id	status	total_amount	payment_status
1	ORD-10001	46	shipped	55.32	captured
2	ORD-10002	19

order_id	order_number	customer_id	status	total_amount	payment_status
1	ORD-10001	46	shipped	55.32	captured
2	ORD-10002	19

payment_id	order_id	method	amount	status
1	1	apple_pay	55.32	captured
2	2	google_pay	662.48	partial_refund

payment_id	order_id	method	amount	status
1	1	apple_pay	55.32	captured
2	2	google_pay	662.48	partial_refund

2606. Customers with Orders but No Captured Payments

Relevant companies

Tags

2606. Customers with Orders but No Captured Payments

Relevant companies

Tags

Sign in to Practice