00:00

2603. Customers with Delivered Orders AND Captured Payments

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

2603. Customers with Delivered Orders AND Captured Payments

Medium114 / 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 Customer Success Analyst at Amazon. The Finance team is analyzing payment reconciliation and customer satisfaction metrics. They need to identify customers who have both successfully completed order deliveries AND have successfully processed (captured) payments, as these customers represent the most reliable and valuable segment for targeted retention campaigns.

Your task is to find all customers who meet both criteria: they have at least one delivered order AND at least one captured payment (not necessarily on the same order).

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id

Business Problem

Your task is to find all customers who meet both criteria: they have at least one delivered order AND at least one captured payment (not necessarily on the same order).

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id

Customers with Delivered Orders AND Captured Payments — SQL Medium | Let's Data Science | Let's Data Science

1	ORD-10001	46	2025-08-20 07:01:34	shipped	pickup				pickup	50.96	0.0	4.36	0.0	55.32	captured	2025-08-20 07:01:34
2	ORD-10002	19	2025-02-24 04:56:03	delivered	ship

1	ORD-10001	46	2025-08-20 07:01:34	shipped	pickup				pickup	50.96	0.0	4.36	0.0	55.32	captured	2025-08-20 07:01:34
2	ORD-10002	19	2025-02-24 04:56:03	delivered	ship

Column Name	Type
payment_id	INTEGER
order_id	INTEGER
method	TEXT
processor	TEXT
amount	REAL
currency	TEXT

2603. Customers with Delivered Orders AND Captured Payments

Relevant companies

Tags

2603. Customers with Delivered Orders AND Captured Payments

Relevant companies

Tags

Sign in to Practice