/* Проверка совпадения территории продажи и территории перепродавца (магазина) */
select fr.*
from FactResellerSales as fr 
     inner join DimReseller as r
                on fr.ResellerKey=r.ResellerKey
     inner join DimGeography as g
                on r.GeographyKey=g.GeographyKey
     inner join DimSalesTerritory as t
                on g.SalesTerritoryKey=t.SalesTerritoryKey
     where fr.SalesTerritoryKey<>t.SalesTerritoryKey