Execute the following Microsoft SQL Server T-SQL SELECT query in SSMS Query Editor to find the last order date and the number of orders for the employee and his/her manager:

-- T-SQL get last order date by salesperson

USE AdventureWorks;

SELECT   SalesStaff = C.LastName + ', ' + C.FirstName,

         OE.NoOfOrders,

         OE.LastOrderDate,

         Manager = CM.LastName + ', ' + CM.FirstName,

         OM.NoOfOrders,

         OM.LastOrderDate

FROM     Person.Contact AS C

         JOIN HumanResources.Employee AS E

           ON C.ContactID = E.ContactID

         JOIN (SELECT   EmployeeID,

                        COUNT(* ),

                        MAX(OrderDate)

               FROM     Purchasing.PurchaseOrderHeader

               GROUP BY EmployeeID) AS OE(EmployeeID,NoOfOrders,LastOrderDate)

           ON E.EmployeeID = OE.EmployeeID

         LEFT OUTER JOIN (SELECT   EmployeeID,

                                   COUNT(* ),

                                   MAX(OrderDate)

                          FROM     Purchasing.PurchaseOrderHeader

                          GROUP BY EmployeeID) AS OM(EmployeeID,NoOfOrders,LastOrderDate)

           ON E.ManagerID = OM.EmployeeID

         JOIN HumanResources.Employee AS EM

           ON OM.EmployeeID = EM.EmployeeID

         JOIN Person.Contact AS CM

           ON EM.ContactID = CM.ContactID

ORDER BY Manager,

         SalesStaff