00:00

1004. High-Value US Orders (Shipped/Delivered)

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

1004. High-Value US Orders (Shipped/Delivered)

Medium5 / 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 logistics analyst at Wayfair, a large online retailer of home goods. To manage customer expectations and proactively handle any potential shipping issues, your team needs a priority list of high-value orders that are currently in the final stages of fulfillment (either shipped or already delivered). This list helps the support team focus on the most critical orders.

Your task is to query the orders table for all US orders that have a total_amount of $100 or more, a payment_status of 'captured', and an order status of either 'shipped' or 'delivered'.

The final list should be sorted by the order_datetime to show the most recent orders first.

Schema: orders

Column Name

Business Problem

Your task is to query the orders table for all US orders that have a total_amount of $100 or more, a payment_status of 'captured', and an order status of either 'shipped' or 'delivered'.

The final list should be sorted by the order_datetime to show the most recent orders first.

Schema: orders

Column Name

High-Value US Orders (Shipped/Delivered) — SQL Medium | Let's Data Science | Let's Data Science

order_id	INTEGER
order_number	TEXT
customer_id	INTEGER
order_datetime	TEXT
status	TEXT
fulfillment_type	TEXT
ship_city	TEXT
ship_state	TEXT
ship_country	TEXT

order_id	INTEGER
order_number	TEXT
customer_id	INTEGER
order_datetime	TEXT
status	TEXT
fulfillment_type	TEXT
ship_city	TEXT
ship_state	TEXT
ship_country	TEXT

order_id	order_number	status	total_amount	order_datetime
35	ORD-10035	shipped	105.78	2025-08-31 15:38:05
54	ORD-10054	shipped	118.76	2025-08-25 03:46:13
15	ORD-10015	delivered	131.01	2025-08-21 08:37:53

order_id	order_number	status	total_amount	order_datetime
35	ORD-10035	shipped	105.78	2025-08-31 15:38:05
54	ORD-10054	shipped	118.76	2025-08-25 03:46:13
15	ORD-10015	delivered	131.01	2025-08-21 08:37:53

1	ORD-10001	46	2025-08-20 07:01:34	shipped	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

1004. High-Value US Orders (Shipped/Delivered)

Relevant companies

Tags

1004. High-Value US Orders (Shipped/Delivered)

Relevant companies

Tags

Sign in to Practice