For every product show category_id, product_name, price and category_avg:
the average price of the products in the same category, rounded to 2 decimal places.
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, price and category_avg:
the average price of the products in the same category, rounded to 2 decimal places.
End your query with ORDER BY category_id, product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| category_id | product_name | price | category_avg |
|---|---|---|---|
| 1 | Nova X5 Smartphone | 24999.00 | 22214.17 |
| 1 | VoltBook Air 14 Laptop | 68990.00 | 22214.17 |
| 1 | BassBoom Headphones | 2999.00 | 22214.17 |
| 1 | PixelTab 11 Tablet | 32999.00 | 22214.17 |
| 1 | USB-C Fast Charger 65W | 1499.00 | 22214.17 |
| 1 | Smart Desk Lamp | 1799.00 | 22214.17 |
| 2 | The Alchemist | 350.00 | 969.20 |
| 2 | Atomic Habits | 899.00 | 969.20 |
| 2 | UPSC Mains Guide 2026 | 1299.00 | 969.20 |
| 2 | Midnight Mystery Novel | 499.00 | 969.20 |
| 2 | Mystery Thriller Box Set | 1799.00 | 969.20 |
| 3 | Classic White Sneakers | 1999.00 | 1932.33 |
| 3 | Denim Jacket | 2499.00 | 1932.33 |
| 3 | Cotton Kurta - Navy | 1299.00 | 1932.33 |
| 4 | Steel Pressure Cooker 5L | 2199.00 | 3949.00 |
| 4 | Ceramic Dinner Set (18pc) | 3499.00 | 3949.00 |
| 4 | Air Fryer 4.5L | 8999.00 | 3949.00 |
| 4 | Cotton Bedsheet King | 1099.00 | 3949.00 |
| 5 | Yoga Mat Pro 6mm | 999.00 | 2049.00 |
| 5 | Cricket Bat - Kashmir | 1899.00 | 2049.00 |
| 5 | Dumbbell Set 20kg | 2799.00 | 2049.00 |
| 5 | Whey Protein 1kg | 2499.00 | 2049.00 |
| 6 | Vitamin C Serum 30ml | 649.00 | 649.00 |
| 6 | Herbal Shampoo 650ml | 499.00 | 649.00 |
| 6 | Matte Lipstick Set (6) | 799.00 | 649.00 |
| 7 | Basmati Rice 5kg | 749.00 | 725.67 |
| 7 | Cold-Pressed Oil 1L | 329.00 | 725.67 |
| 7 | Assorted Dry Fruits 1kg | 1099.00 | 725.67 |
| 8 | Building Blocks 250pc | 1499.00 | 1565.67 |
| 8 | Strategy Board Game | 1199.00 | 1565.67 |
| 8 | RC Stunt Car | 1999.00 | 1565.67 |
Run query to see output