Execute the following script in Query Editor to build a sales report by sales territory, region and sales person.

USE AdventureWorks

GO

SELECT

      SalesTerritory=ST.[Group],

      Region = ST.Name, SP.SalesPersonID,

      SalesPerson=C.FirstName+' '+C.LastName,

      SalesItem = count(*),

      TotalDue='$'+convert(varchar,sum(SOH.TotalDue),1) -- currency format

FROM  Sales.SalesTerritory ST

INNER JOIN Sales.SalesPerson SP ON ST.TerritoryID = SP.TerritoryID

INNER JOIN HumanResources.Employee E ON SP.SalesPersonID =  E.EmployeeID

INNER JOIN Person.Contact C ON E.ContactID = C.ContactID

INNER JOIN Sales.SalesOrderHeader SOH ON SP.SalesPersonID = SOH.SalesPersonID

GROUP BY

ST.[Group],

ST.Name,

SP.SalesPersonID,

C.FirstName,

C.LastName

HAVING (ST.[Group] IN ('North America'))

ORDER BY ST.Name