The warehouse packs products in boxes of 12. For each product, show product_name,
stock and:
full_boxes: how many boxes of 12 can be filled completelyloose_units: the units left over after filling themboxes_needed: the boxes needed to pack every unit, where a part-filled box also counts
(a product with no stock needs 0)End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| stock |
The warehouse packs products in boxes of 12. For each product, show product_name,
stock and:
full_boxes: how many boxes of 12 can be filled completelyloose_units: the units left over after filling themboxes_needed: the boxes needed to pack every unit, where a part-filled box also counts
(a product with no stock needs 0)End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| stock |
| product_name | stock | full_boxes | loose_units | boxes_needed |
|---|---|---|---|---|
| Nova X5 Smartphone | 120 | 10 | 0 | 10 |
| VoltBook Air 14 Laptop | 45 | 3 | 9 | 4 |
| BassBoom Headphones | 300 | 25 | 0 | 25 |
| PixelTab 11 Tablet | 0 | 0 | 0 | 0 |
| The Alchemist | 500 | 41 | 8 | 42 |
| Atomic Habits | 250 | 20 | 10 | 21 |
| UPSC Mains Guide 2026 | 180 | 15 | 0 | 15 |
| Midnight Mystery Novel | 0 | 0 | 0 | 0 |
| Classic White Sneakers | 200 | 16 | 8 | 17 |
| Denim Jacket | 90 | 7 | 6 | 8 |
| Cotton Kurta - Navy | 150 | 12 | 6 | 13 |
| Steel Pressure Cooker 5L | 110 | 9 | 2 | 10 |
| Ceramic Dinner Set (18pc) | 60 | 5 | 0 | 5 |
| Air Fryer 4.5L | 35 | 2 | 11 | 3 |
| Yoga Mat Pro 6mm | 400 | 33 | 4 | 34 |
| Cricket Bat - Kashmir | 75 | 6 | 3 | 7 |
| Dumbbell Set 20kg | 50 | 4 | 2 | 5 |
| Vitamin C Serum 30ml | 220 | 18 | 4 | 19 |
| Herbal Shampoo 650ml | 320 | 26 | 8 | 27 |
| Matte Lipstick Set (6) | 0 | 0 | 0 | 0 |
| Basmati Rice 5kg | 600 | 50 | 0 | 50 |
| Cold-Pressed Oil 1L | 450 | 37 | 6 | 38 |
| Assorted Dry Fruits 1kg | 130 | 10 | 10 | 11 |
| Building Blocks 250pc | 140 | 11 | 8 | 12 |
| Strategy Board Game | 95 | 7 | 11 | 8 |
| RC Stunt Car | 40 | 3 | 4 | 4 |
| USB-C Fast Charger 65W | 260 | 21 | 8 | 22 |
| Whey Protein 1kg | 80 | 6 | 8 | 7 |
| Mystery Thriller Box Set | 70 | 5 | 10 | 6 |
| Cotton Bedsheet King | 170 | 14 | 2 | 15 |
| Smart Desk Lamp | 25 | 2 | 1 | 3 |
Run query to see output