SELECT P.Name,L.Name,PInve.Quantity,
(SELECT SUM(Quantity) FROM Production.ProductInventory AS Pinve WHERE P.ProductID = Pinve.ProductID)
AS 'Ukupno stanje na svim lokacijama',
(SELECT SUM(SOD.OrderQty)
 FROM Sales.SalesOrderDetail AS SOD WHERE SOD.ProductID=P.ProductID) AS 'Ukupno prodano'
 --SOH.OrderDate
FROM Production.Product AS P
	JOIN Production.ProductInventory AS PInve
		ON P.ProductID = PInve.ProductID
		JOIN Production.Location AS L
		ON PInve.LocationID = L.LocationID
		WHERE YEAR(P.SellEndDate) = 2013 OR YEAR(P.SellStartDate)=2013