Product Line Sales - Source code

/* ***** Source for query: TopEmployees ***** */

SELECT TOP 5 C.LastName, C.FirstName, E.EmployeeID, SUM(SOH.SubTotal) AS SaleAmount
FROM Sales.SalesPerson SP 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 INNER JOIN
Sales.SalesOrderDetail SOD ON SOH.SalesOrderID = SOD.SalesOrderID INNER JOIN
Production.Product P ON SOD.ProductID = P.ProductID INNER JOIN
Production.ProductSubcategory PS ON P.ProductSubcategoryID = PS.ProductSubcategoryID INNER JOIN
Production.ProductCategory PC ON PS.ProductCategoryID = PC.ProductCategoryID
WHERE    (PC.ProductCategoryID = @ProductCategory) AND (PS.ProductSubcategoryID IN (@ProductSubcategory)) AND
(SOH.OrderDate > @StartDate) AND (SOH.OrderDate < @EndDate)
GROUP BY C.LastName, C.FirstName, E.EmployeeID, PC.ProductCategoryID, PS.ProductSubcategoryID

/* ***** Source for query: ProductCategories ***** */

SELECT DISTINCT ProductCategoryID, Name
FROM Production.ProductCategory
ORDER BY Name

/* ***** Source for query: TopCustomers ***** */

SELECT TOP 5 S.Name AS StoreName, SUM(SOH.SubTotal) AS SaleAmount, PS.ProductSubcategoryID,
PS.ProductCategoryID
FROM Production.Product P INNER JOIN
Production.ProductSubcategory PS ON P.ProductSubCategoryID = PS.ProductSubCategoryID INNER JOIN
Sales.SalesOrderDetail SOD ON P.ProductID = SOD.ProductID INNER JOIN
Sales.Customer CU INNER JOIN
Sales.SalesOrderHeader SOH ON CU.CustomerID = SOH.CustomerID INNER JOIN
Sales.Store S ON CU.CustomerID = S.CustomerID ON SOD.SalesOrderID = SOH.SalesOrderID
WHERE    (SOH.OrderDate > @StartDate) AND
(SOH.OrderDate < @EndDate) AND (PS.ProductCategoryID = @ProductCategory) AND (PS.ProductSubcategoryID IN (@ProductSubcategory))
GROUP BY S.Name, PS.ProductSubcategoryID, PS.ProductCategoryID
ORDER BY SUM(SOH.SubTotal) DESC

/* ***** Source for query: ProductSubCategories ***** */

SELECT ProductSubcategoryID, ProductCategoryID, Name
FROM Production.ProductSubcategory
WHERE    (ProductCategoryID = @ProductCategory)