1. Engineering
  2. Computer Science
  3. database processing fundamentals design and implementation 15th ed unit 1...

Question: database processing fundamentals design and implementation 15th ed unit 1...

Question details

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.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution