00:00

2007. Two Newest Active Items per Category

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

2007. Two Newest Active Items per Category

Medium70 / 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 Category Manager at Target. The team needs to spotlight the newest additions across categories. For each category, your task is to show the two most recently added active items with their names and prices, including a rank of 1 (newest) and 2 (next). Sort categories alphabetically; within each category, show most recent first and break ties by the smallest item identifier. Only include items that are currently active.

Schema: products

Column Name	Type
product_id	INTEGER
sku	TEXT
product_name	TEXT

Business Problem

Schema: products

Column Name	Type
product_id	INTEGER
sku	TEXT
product_name	TEXT

Two Newest Active Items per Category — SQL Medium | Let's Data Science | Let's Data Science

category	product_id	product_name	price	category_rank
Apparel	26	Hanes ComfortSoft T-Shirt 6-Pack	21.0	1
Apparel	46	Nike Air Force 1 '07	110.0	2
Beauty	47	Paula's Choice 2% BHA Exfoliant	34.0	1

category	product_id	product_name	price	category_rank
Apparel	26	Hanes ComfortSoft T-Shirt 6-Pack	21.0	1
Apparel	46	Nike Air Force 1 '07	110.0	2
Beauty	47	Paula's Choice 2% BHA Exfoliant	34.0	1

2007. Two Newest Active Items per Category

Relevant companies

Tags

2007. Two Newest Active Items per Category

Relevant companies

Tags

Sign in to Practice