For every product show product_name, price and two rankings, 1 for the most
expensive:
price_rank: products with the same price share a rank, and the next rank skips, like 1, 2, 2, 4price_level: the same, but without gaps, like 1, 2, 2, 3End your query with ORDER BY price DESC, product_name.
| products |
|---|
| product_id (PK) |
| product_name |
| price |
For every product show product_name, price and two rankings, 1 for the most
expensive:
price_rank: products with the same price share a rank, and the next rank skips, like 1, 2, 2, 4price_level: the same, but without gaps, like 1, 2, 2, 3End your query with ORDER BY price DESC, product_name.
| products |
|---|
| product_id (PK) |
| product_name |
| price |
| product_name | price | price_rank | price_level |
|---|---|---|---|
| VoltBook Air 14 Laptop | 68990.00 | 1 | 1 |
| PixelTab 11 Tablet | 32999.00 | 2 | 2 |
| Nova X5 Smartphone | 24999.00 | 3 | 3 |
| Air Fryer 4.5L | 8999.00 | 4 | 4 |
| Ceramic Dinner Set (18pc) | 3499.00 | 5 | 5 |
| BassBoom Headphones | 2999.00 | 6 | 6 |
| Dumbbell Set 20kg | 2799.00 | 7 | 7 |
| Denim Jacket | 2499.00 | 8 | 8 |
| Whey Protein 1kg | 2499.00 | 8 | 8 |
| Steel Pressure Cooker 5L | 2199.00 | 10 | 9 |
| Classic White Sneakers | 1999.00 | 11 | 10 |
| RC Stunt Car | 1999.00 | 11 | 10 |
| Cricket Bat - Kashmir | 1899.00 | 13 | 11 |
| Mystery Thriller Box Set | 1799.00 | 14 | 12 |
| Smart Desk Lamp | 1799.00 | 14 | 12 |
| Building Blocks 250pc | 1499.00 | 16 | 13 |
| USB-C Fast Charger 65W | 1499.00 | 16 | 13 |
| Cotton Kurta - Navy | 1299.00 | 18 | 14 |
| UPSC Mains Guide 2026 | 1299.00 | 18 | 14 |
| Strategy Board Game | 1199.00 | 20 | 15 |
| Assorted Dry Fruits 1kg | 1099.00 | 21 | 16 |
| Cotton Bedsheet King | 1099.00 | 21 | 16 |
| Yoga Mat Pro 6mm | 999.00 | 23 | 17 |
| Atomic Habits | 899.00 | 24 | 18 |
| Matte Lipstick Set (6) | 799.00 | 25 | 19 |
| Basmati Rice 5kg | 749.00 | 26 | 20 |
| Vitamin C Serum 30ml | 649.00 | 27 | 21 |
| Herbal Shampoo 650ml | 499.00 | 28 | 22 |
| Midnight Mystery Novel | 499.00 | 28 | 22 |
| The Alchemist | 350.00 | 30 | 23 |
| Cold-Pressed Oil 1L | 329.00 | 31 | 24 |
Run query to see output