00:00

2004. Latest Captured Payment per Purchase

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

2004. Latest Captured Payment per Purchase

Medium67 / 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 Finance Operations Analyst at Amazon. The team reviews the latest successful payment for each completed purchase. Your task is to provide, for every purchase, the most recent captured payment along with the amount, method, provider, and capture time. Show results in ascending order of the purchase identifier; break any remaining ties by the smallest payment identifier. Exclude any payments that were not successfully captured or that do not have a recorded capture time.

Schema: payments

Column Name	Type
payment_id	INTEGER
order_id	INTEGER
method	TEXT

Business Problem

Schema: payments

Column Name	Type
payment_id	INTEGER
order_id	INTEGER
method	TEXT

Latest Captured Payment per Purchase — SQL Medium | Let's Data Science | Let's Data Science

order_id	payment_id	capture_time	amount	method	processor	payment_rank
1	1	2025-08-20 15:01:34	55.32	apple_pay	stripe	1
3	3	2025-02-14 16:43:43	88.66	bank_trans	internal

order_id	payment_id	capture_time	amount	method	processor	payment_rank
1	1	2025-08-20 15:01:34	55.32	apple_pay	stripe	1
3	3	2025-02-14 16:43:43	88.66	bank_trans	internal

2004. Latest Captured Payment per Purchase

Relevant companies

Tags

2004. Latest Captured Payment per Purchase

Relevant companies

Tags

Sign in to Practice