Question: database processing fundamentals design and implementation 15th ed unit 1...
Database Processing Fundamentals, Design, and Implementation 15th Ed.
Unit 1: 2.52
Write an SQL statement to display the WarehouseID, the sum of QuantityOnOrder, and the sum of QuantityOnHand, grouped by WarehouseID and QuantityOnOrder. Name the sum of QuantityOnOrder as TotalItemsOnOrder and the sum of QuantityOnHand as TotalItemsOnHand. Use only the INVENTORY table in your SQL statement.