Write SQL and Python, run instantly in your browser, and track your progress.
You are a Pricing Analyst at Best Buy. The Category team wants to rank products by price using dense ranking (no gaps). Rank products by price in descending order where tied prices get the same rank, and the next price gets the immediately following rank number.
| Column Name | Type |
|---|---|
| product_id | int64 |
| product_name | object |
| category | object |
| price | float64 |
You are a Pricing Analyst at Best Buy. The Category team wants to rank products by price using dense ranking (no gaps). Rank products by price in descending order where tied prices get the same rank, and the next price gets the immediately following rank number.
| Column Name | Type |
|---|---|
| product_id | int64 |
| product_name | object |
| category | object |
| price | float64 |
| product_id | product_name | category | price |
|---|---|---|---|
| 1 | Wireless Headphones | Electronics | 149.99 |
| 2 | Smart Watch | Electronics | 299.99 |
| 3 | USB Cable | Electronics |
| product_id | product_name | category | price |
|---|---|---|---|
| 1 | Wireless Headphones | Electronics | 149.99 |
| 2 | Smart Watch | Electronics | 299.99 |
| 3 | USB Cable | Electronics |
| product_id | product_name | price | price_rank |
|---|---|---|---|
| 1 | Casper Original Mattress Queen | 1095 | 1 |
| 44 | All-Clad D3 Stainless 10-Piece Set | 699.99 | 2 |
| 38 | Uplift V2 Standing Desk | 599 | 3 |
| 2 | Dyson Supersonic Hair Dryer | 429.99 |
| product_id | product_name | price | price_rank |
|---|---|---|---|
| 1 | Casper Original Mattress Queen | 1095 | 1 |
| 44 | All-Clad D3 Stainless 10-Piece Set | 699.99 | 2 |
| 38 | Uplift V2 Standing Desk | 599 | 3 |
| 2 | Dyson Supersonic Hair Dryer | 429.99 |
Showing first 5 of 50 rows.
Showing first 5 of 50 rows.
1. Data Selection:
2. Ranking:
3. Output:
1. Data Selection:
2. Ranking:
3. Output:
| 15.99 |
| 15.99 |
| 4 | Bluetooth Speaker | Electronics | 149.99 |
| 4 | Bluetooth Speaker | Electronics | 149.99 |
| 5 | Laptop Stand | Electronics | 49.99 |
| 5 | Laptop Stand | Electronics | 49.99 |
| 4 |
| 4 |
| 3 | CalDigit TS4 Thunderbolt Dock | 399.99 | 5 |
| 3 | CalDigit TS4 Thunderbolt Dock | 399.99 | 5 |