/* Which employees have sold the highest & lowest number of bikes to customers
in Washington State and Utah before March 9, 2008? */

SELECT * FROM [Person].[CountryRegion] CR
JOIN [Sales].[SalesTerritory] ST ON CR.CountryRegionCode = ST.CountryRegionCode
JOIN [Sales].[SalesOrderHeader] SOH ON ST.TerritoryID = SOH.TerritoryID
JOIN [Sales].[SalesOrderDetail] SOD ON SOH.SalesOrderID = SOD.SalesOrderID
JOIN [Sales].[SpecialOfferProduct] SOP ON SOD.ProductID = SOP.ProductID
JOIN [Production].[Product] Pr ON SOP.ProductID = Pr.ProductID
JOIN [Production].[ProductCategory] PC ON Pr.ProductSubcategoryID = PC.ProductCategoryID
JOIN [Sales].[SalesPerson] SP ON ST.TerritoryID = SP.TerritoryID
JOIN [Person].[Person] Pe ON SP.BusinessEntityID = PE.BusinessEntityID