00:00

1763. Products With Deliveries But No Returns (Last 120 Days)

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

1763. Products With Deliveries But No Returns (Last 120 Days)

Hard62 / 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 Product Quality Analyst at Amazon. The Product Operations team wants to identify high-quality products with strong customer satisfaction indicators. Products that have been delivered successfully without any returns in the same period represent items with excellent quality and accurate product descriptions. Using the last 120 days, your task is to list these zero-return products along with their delivered unit counts to highlight top-performing inventory.

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id	INTEGER

Business Problem

Schema: orders

Column Name	Type
order_id	INTEGER
order_number	TEXT
customer_id	INTEGER

Products With Deliveries But No Returns (Last 120 Days) — SQL Hard | Let's Data Science | Let's Data Science

product_id	product_name	units_delivered
22	Apple Magic Keyboard	6
59	Blue Yeti USB Microphone	6
102	Keurig K-Elite Coffee Maker	6

product_id	product_name	units_delivered
22	Apple Magic Keyboard	6
59	Blue Yeti USB Microphone	6
102	Keurig K-Elite Coffee Maker	6

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_item_id	INTEGER
order_id	INTEGER
product_id	INTEGER
quantity	INTEGER
unit_price	REAL
line_subtotal	REAL

1763. Products With Deliveries But No Returns (Last 120 Days)

Relevant companies

Tags

1763. Products With Deliveries But No Returns (Last 120 Days)

Relevant companies

Tags

Sign in to Practice