00:00

1264. US Orders With Any Two-Day Shipment

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

1264. US Orders With Any Two-Day Shipment

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

Operations needs to find US orders that used the two-day service for any of their shipments and meet a minimum total amount. Provide the order identifier, order number, fulfillment status, and shipping service level. Sort by most recent order date first; break ties by the smallest 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

US Orders With Any Two-Day Shipment — SQL Medium | Let's Data Science | Let's Data Science

order_id	order_number	status	shipping_service_level
35	ORD-10035	shipped	two_day
54	ORD-10054	shipped	two_day
47	ORD-10047	packed	two_day
32	ORD-10032	confirmed	two_day

order_id	order_number	status	shipping_service_level
35	ORD-10035	shipped	two_day
54	ORD-10054	shipped	two_day
47	ORD-10047	packed	two_day
32	ORD-10032	confirmed	two_day

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
shipment_id	INTEGER
order_id	INTEGER
warehouse_code	TEXT
carrier_name	TEXT
service_level	TEXT
tracking_number	TEXT

1264. US Orders With Any Two-Day Shipment

Relevant companies

Tags

1264. US Orders With Any Two-Day Shipment

Relevant companies

Tags

Sign in to Practice