SELECT Podkategoria,  Produkt,
			Sum(Kwota) OVER(PARTITION BY Podkategoria, Produkt) AS "Kwota",
			Sum(Kwota) OVER (PARTITION BY Podkategoria ORDER BY Produkt ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS "Suma narastająco"
FROM(
	SELECT PSC.Name AS "Podkategoria", P.Name AS "Produkt",  Sum(SOD.LineTotal) AS "Kwota"
			--Sum(SOD.LineTotal) OVER(PARTITION BY PSC.Name, P.Name) AS "Kwota",
			--Sum(SOD.LineTotal) OVER (PARTITION BY PSC.Name, P.Name ORDER BY P.Name ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS "Suma narastająco"
	FROM Sales.SalesOrderDetail AS "SOD"
		 RIGHT JOIN Production.Product AS "P" ON(SOD.ProductID = P.ProductID)
		 JOIN Production.ProductSubcategory AS "PSC" ON(P.ProductSubcategoryID = PSC.ProductSubcategoryID)
	GROUP BY P.Name, PSC.Name) AS "t"
	--ORDER BY PSC.Name, Sum(SOD.LineTotal);