For every product show category_id, product_name, and on the same row:
cheapest: the name of the cheapest product in its categorypriciest: the name of the most expensive product in its categoryWhen two products have the same price, the one with the lower product_id counts as cheaper.
End your query with ORDER BY category_id, product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
For every product show category_id, product_name, and on the same row:
cheapest: the name of the cheapest product in its categorypriciest: the name of the most expensive product in its categoryWhen two products have the same price, the one with the lower product_id counts as cheaper.
End your query with ORDER BY category_id, product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| category_id | product_name | cheapest | priciest |
|---|---|---|---|
| 1 | Nova X5 Smartphone | USB-C Fast Charger 65W | VoltBook Air 14 Laptop |
| 1 | VoltBook Air 14 Laptop | USB-C Fast Charger 65W | VoltBook Air 14 Laptop |
| 1 | BassBoom Headphones | USB-C Fast Charger 65W | VoltBook Air 14 Laptop |
| 1 | PixelTab 11 Tablet | USB-C Fast Charger 65W | VoltBook Air 14 Laptop |
| 1 | USB-C Fast Charger 65W | USB-C Fast Charger 65W | VoltBook Air 14 Laptop |
| 1 | Smart Desk Lamp | USB-C Fast Charger 65W | VoltBook Air 14 Laptop |
| 2 | The Alchemist | The Alchemist | Mystery Thriller Box Set |
| 2 | Atomic Habits | The Alchemist | Mystery Thriller Box Set |
| 2 | UPSC Mains Guide 2026 | The Alchemist | Mystery Thriller Box Set |
| 2 | Midnight Mystery Novel | The Alchemist | Mystery Thriller Box Set |
| 2 | Mystery Thriller Box Set | The Alchemist | Mystery Thriller Box Set |
| 3 | Classic White Sneakers | Cotton Kurta - Navy | Denim Jacket |
| 3 | Denim Jacket | Cotton Kurta - Navy | Denim Jacket |
| 3 | Cotton Kurta - Navy | Cotton Kurta - Navy | Denim Jacket |
| 4 | Steel Pressure Cooker 5L | Cotton Bedsheet King | Air Fryer 4.5L |
| 4 | Ceramic Dinner Set (18pc) | Cotton Bedsheet King | Air Fryer 4.5L |
| 4 | Air Fryer 4.5L | Cotton Bedsheet King | Air Fryer 4.5L |
| 4 | Cotton Bedsheet King | Cotton Bedsheet King | Air Fryer 4.5L |
| 5 | Yoga Mat Pro 6mm | Yoga Mat Pro 6mm | Dumbbell Set 20kg |
| 5 | Cricket Bat - Kashmir | Yoga Mat Pro 6mm | Dumbbell Set 20kg |
| 5 | Dumbbell Set 20kg | Yoga Mat Pro 6mm | Dumbbell Set 20kg |
| 5 | Whey Protein 1kg | Yoga Mat Pro 6mm | Dumbbell Set 20kg |
| 6 | Vitamin C Serum 30ml | Herbal Shampoo 650ml | Matte Lipstick Set (6) |
| 6 | Herbal Shampoo 650ml | Herbal Shampoo 650ml | Matte Lipstick Set (6) |
| 6 | Matte Lipstick Set (6) | Herbal Shampoo 650ml | Matte Lipstick Set (6) |
| 7 | Basmati Rice 5kg | Cold-Pressed Oil 1L | Assorted Dry Fruits 1kg |
| 7 | Cold-Pressed Oil 1L | Cold-Pressed Oil 1L | Assorted Dry Fruits 1kg |
| 7 | Assorted Dry Fruits 1kg | Cold-Pressed Oil 1L | Assorted Dry Fruits 1kg |
| 8 | Building Blocks 250pc | Strategy Board Game | RC Stunt Car |
| 8 | Strategy Board Game | Strategy Board Game | RC Stunt Car |
| 8 | RC Stunt Car | Strategy Board Game | RC Stunt Car |
Run query to see output