SELECT CompanyName, [Beverages], [Condiments], [Confections], [Dairy Products], [Grains/Cereals], [Meat/Poultry], [Produce], [Seafood]
FROM (
	  SELECT SUP.CompanyName, CAT.CategoryName AS [Категория товара], PR.UnitPrice
	  FROM Northwind..Suppliers AS SUP
	  INNER JOIN
		   Northwind..Products AS PR
	  ON SUP.SupplierID = PR.SupplierID
	  INNER JOIN
		  Northwind..Categories AS CAT
	  ON PR.CategoryID = CAT.CategoryID
) AS MyTab
pivot
	 (AVG(MyTab.UnitPrice) FOR [Категория товара] IN ([Beverages], [Condiments], [Confections], [Dairy Products], [Grains/Cereals], [Meat/Poultry], [Produce], [Seafood])) AS MyReport

SELECT CompanyName, [Beverages], [Condiments], [Confections], [Dairy Products], [Grains/Cereals], [Meat/Poultry], [Produce], [Seafood], [LowCost], [MediumCost], [HighCost] -- Добавленные ценовые катеогрии
FROM (
	  SELECT SUP.CompanyName, CAT.CategoryName AS [Категория товара], PR.UnitPrice, CT.CostCategory AS [Ценовая категория]
	  FROM Northwind..Suppliers AS SUP
	  INNER JOIN
		   Northwind..Products AS PR
	  ON SUP.SupplierID = PR.SupplierID
	  INNER JOIN
		  Northwind..Categories AS CAT
	  ON PR.CategoryID = CAT.CategoryID
          INNER JOIN
		  Northwind..CostCategory AS CT -- добавленный JOIN
	  ON PR.CostCategoryID = CT.CostCategoryID
) AS MyTab
pivot
	 (AVG(MyTab.UnitPrice) FOR [Категория товара] IN ([Beverages], [Condiments], [Confections], [Dairy Products], [Grains/Cereals], [Meat/Poultry], [Produce], [Seafood]),
FOR [Ценовая категория] IN ([LowCost], [MediumCost], [HighCost]) -- вот собственно и главный вопрос. Можно ли в FOR перечислить столбцы?
) AS MyReport