SELECT Таблица1.Week_, Таблица1.Category, Таблица1.Country, Таблица1.Comments, Sum([Ordered, cases]/(SELECT count(*) AS num FROM (SELECT DISTINCT [Global Reasons] FROM Таблица1)  AS [num];)) AS ordered, Sum(Таблица1.[Delta, cases]) AS [Sum-Delta, cases], [Sum-Delta, cases]/(SELECT Sum(a.[Ordered, cases]/(SELECT count(*) AS num FROM (SELECT DISTINCT [Global Reasons] FROM Таблица1 )  AS [num];)) AS [Sum-Ordered, cases]
FROM Таблица1 a inner join  Claster b ON a.country=b.counrty
GROUP BY a.Week_, a.Category,b.Claster
HAVING Таблица1.Week_=a.Week_ and Таблица1.Category=a.Category and Claster.claster=b.claster
) AS OOS, Таблица1.[Global Reasons], Claster.claster
FROM Таблица1 INNER JOIN Claster ON Таблица1.Country = Claster.counrty
GROUP BY Таблица1.Week_, Таблица1.Category, Таблица1.Country, Таблица1.Comments, Таблица1.[Global Reasons], Claster.claster;