INVENTORY Required Remarks Column Name Type Key Primary Key, Yes Surrogate Key F

Question

INVENTORY Required Remarks Column Name Type Key Primary Key, Yes Surrogate Key Foreign Key Primary Key, Yes Surrogate Key Foreign Key No Yes Text (35) SKU-Description QuantityonHand Integer Quantityononder Integer No No

Explanation / Answer

/* 2.17 */ SELECT SKU, SKU_Description FROM inventory; /* 2.18 */ SELECT SKU_Description, SKU FROM inventory; /* 2.19 */ SELECT WarehouseID FROM inventory; /* 2.20 */ SELECT DISTINCT WarehouseID FROM inventory; /* 2.21 */ SELECT WarehouseID,SKU,SKU_Description,QuantityOnHand,QuantityOnOrder FROM INVENTORY; /* 2.22 */ SELECT * FROM INVENTORY; /* 2.23 */ SELECT * FROM INVENTORY where QuantityOnHand > 0; /* 2.24 */ SELECT SKU,SKU_Description FROM INVENTORY where QuantityOnHand = 0; /* 2.25 */ SELECT SKU,SKU_Description, WarehouseID FROM INVENTORY where QuantityOnHand = 0 ORDER BY WarehouseID ASC; /* 2.26 */ SELECT SKU,SKU_Description, WarehouseID FROM INVENTORY where QuantityOnHand > 0 ORDER BY WarehouseID DESC, SKU ASC; /* 2.27 */ SELECT SKU,SKU_Description, WarehouseID FROM INVENTORY where QuantityOnHand = 0 AND QuantityOnOrder > 0 ORDER BY WarehouseID DESC, SKU ASC;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.