IS
если воду и воздух убрать, то примерно так
Size: a a a
IS
Л
IS
IS
ДT
МР
PW
SELECT
YEAR(SOH.OrderDate) Rok,
COUNT(SOH.OrderDate) "Liczba zamowien",
ST.[Name] Terytorium,
COUNT(SOH.OrderDate) "Liczba zam. na terytorium"
FROM Sales.SalesOrderHeader AS SOH
JOIN Sales.SalesTerritory AS ST
ON SOH.TerritoryID = ST.TerritoryID
GROUP BY YEAR(SOH.OrderDate), ST.[Name]
ORDER BY YEAR(SOH.OrderDate), ST.[Name];
PW
PW