Write an SQL statement to display the WarehouseID, the sum of QuantityOnOrder and sum of QuantityOnHand, grouped
Question:
Write an SQL statement to display the WarehouseID, the sum of QuantityOnOrder and 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.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
SELECT WarehouseID SUM QuantityOnOrder AS TotalItemsOnOrder QuantityOnHand AS TotalItems OnHa...View the full answer
Answered By
RADHIKA MEENAKAR
I am a qualified indian Company Secretary along with Masters in finance with over 6 plus years of professional experience. Apart from this i am a certified accounts and finance tutor on many online platforms.
My Linkedin profile link is here https://www.linkedin.com/in/radhika-meenakar-88b9808a/
12+ Reviews
22+ Question Solved
Related Book For 
Database Processing Fundamentals, Design, and Implementation
ISBN: 978-0133876703
14th edition
Authors: David M. Kroenke, David J. Auer
Question Posted:
