00:00

2261. Most Recent Captured Payment per Customer (Last 60 Days)

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

2261. Most Recent Captured Payment per Customer (Last 60 Days)

Hard98 / 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 Financial Analyst at Target. The marketing team wants to identify recently active customers for a targeted loyalty campaign. They need to see each customer's most recent successful payment.

Your task is to find the most recent captured payment for each customer within the last 60 days. Exclude any payments linked to canceled orders.

Schema: payments

Column Name	Type
payment_id	INTEGER
order_id	INTEGER
method	TEXT

Business Problem

Your task is to find the most recent captured payment for each customer within the last 60 days. Exclude any payments linked to canceled orders.

Schema: payments

Column Name	Type
payment_id	INTEGER
order_id	INTEGER
method	TEXT

Most Recent Captured Payment per Customer (Last 60 Days) — SQL Hard | Let's Data Science | Let's Data Science

customer_id	payment_id	order_id	capture_time	amount
36	35	35	2025-09-02 16:38:05	105.78
6	54	54	2025-08-25 18:46:13	118.76
44	15	15	2025-08-23 11:37:53	131.01

customer_id	payment_id	order_id	capture_time	amount
36	35	35	2025-09-02 16:38:05	105.78
6	54	54	2025-08-25 18:46:13	118.76
44	15	15	2025-08-23 11:37:53	131.01

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
order_id	INTEGER
order_number	TEXT
customer_id	INTEGER
order_datetime	TEXT
status	TEXT
fulfillment_type	TEXT

2261. Most Recent Captured Payment per Customer (Last 60 Days)

Relevant companies

Tags

2261. Most Recent Captured Payment per Customer (Last 60 Days)

Relevant companies

Tags

Sign in to Practice