Products Ranked by Price Within Category

Problem

A merchandising team wants to see how each product ranks by price within its category. Using the products table, return category, name, price, and a price_rank column that gives each product's rank within its category (1 = most expensive). Order the result by category ascending, then price_rank ascending.

Schema

products

Sample Data

Expected Output

Explanation

Within Accessories, Silk Scarf is the most expensive (rank 1), followed by Leather Wallet (rank 2) and Cotton Tote (rank 3). The ranking resets to 1 for Electronics, where Pro Headphones is the most expensive. The result is sorted by category then by rank within each category.