00:00

1515. Captured Amount by Customer (Delivered Orders)

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

1515. Captured Amount by Customer (Delivered Orders)

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

Finance wants to understand which customers have the highest realized revenue from orders that were delivered. For each customer, compute the total captured payment amount across delivered orders. Sort by the highest captured total; break ties by the smallest customer identifier.

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id	INTEGER
order_datetime	TEXT

Business Problem

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id	INTEGER
order_datetime	TEXT

Captured Amount by Customer (Delivered Orders) — SQL Medium | Let's Data Science | Let's Data Science

customer_id	total_captured_amount
50	2818.19
47	1317.21
36	1074.03
12	444.56
16	149.75

customer_id	total_captured_amount
50	2818.19
47	1317.21
36	1074.03
12	444.56
16	149.75

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

1515. Captured Amount by Customer (Delivered Orders)

Relevant companies

Tags

1515. Captured Amount by Customer (Delivered Orders)

Relevant companies

Tags

Sign in to Practice