00:00

1500. Top Customers by Recent Billed Amount

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

1500. Top Customers by Recent Billed Amount

Medium33 / 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 Data Analyst at Shopify. A top merchant wants to launch a loyalty program and needs to identify their most valuable customers from the last quarter (90 days ending August 30, 2025).

Write a query that returns all customers who have placed a delivered order within this 90-day window. For each customer, show their ID, the count of delivered orders, and the total amount they were billed.

Sort by highest total billed amount first; break ties by smallest customer ID.

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id

Business Problem

You are a Data Analyst at Shopify. A top merchant wants to launch a loyalty program and needs to identify their most valuable customers from the last quarter (90 days ending August 30, 2025).

Sort by highest total billed amount first; break ties by smallest customer ID.

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id

Top Customers by Recent Billed Amount — SQL Medium | Let's Data Science | Let's Data Science

customer_id	delivered_orders	total_billed_amount
12	1	444.56
35	1	180.24
44	1	131.01

customer_id	delivered_orders	total_billed_amount
12	1	444.56
35	1	180.24
44	1	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

1500. Top Customers by Recent Billed Amount

Relevant companies

Tags

1500. Top Customers by Recent Billed Amount

Relevant companies

Tags

Sign in to Practice