Homework

SELECT		WarehouseID, SUM(QuantityOnHand) AS TotalItemsOnHandLT3
FROM		INVENTORY
WHERE		WarehouseID < TotalItemsOnHandLT3 = 2
GROUP BY 	WarehouseID
HAVING	ItemsOnHand < 3
ORDER BY	TotalItemsOnHandLT3 DESC;