00:00

1266. Active Home Products Never Ordered

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

1266. Active Home Products Never Ordered

Medium27 / 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 Merchandising Analyst at Amazon. The team wants to identify active Home products that have never been ordered, to consider them for promotional campaigns or potential discontinuation.

Find all active products in the 'Home' category that have no order history. Return the product identifier, name, category, and price. Sort by lowest price first; break ties by the smallest product identifier.

Schema: products

Column Name	Type
product_id	INTEGER
sku	TEXT
product_name	TEXT

Business Problem

You are a Merchandising Analyst at Amazon. The team wants to identify active Home products that have never been ordered, to consider them for promotional campaigns or potential discontinuation.

Schema: products

Column Name	Type
product_id	INTEGER
sku	TEXT
product_name	TEXT

Active Home Products Never Ordered — SQL Medium | Let's Data Science | Let's Data Science

Column Name	Type
order_item_id	INTEGER
order_id	INTEGER
product_id	INTEGER
quantity	INTEGER
unit_price	REAL
line_subtotal	REAL

1266. Active Home Products Never Ordered

Relevant companies

Tags

1266. Active Home Products Never Ordered

Relevant companies

Tags

Sign in to Practice