GROUP BY

SELECT LocationID,Shelf,Sum(Quantity) AS [Total Quantity]

FROM Production.ProductInventory

WHERE LocationID in (1,5)

GROUP BY LocationID,Shelf

HAVING Sum(Quantity) > 5000

ORDER BY LocationID