AdventureWorks: Retrieve data about latest orders by customer name, date and sales person (ordered by date and grouped by customer name,date and sales person)

AdventureWorksSQL-SOH2.sql

SELECT TOP 10 P.FirstName +' '+P.LastName As ClientName, SOH.OrderDate, SOH.SalesPersonID 
FROM Sales.SalesOrderHeader SOH
JOIN Sales.Customer C ON SOH.CustomerID = C.CustomerID
JOIN Person.Person P ON P.BusinessEntityID = C.PersonID
WHERE SalesPersonID IS NOT NULL
GROUP BY P.FirstName +' '+P.LastName, SOH.OrderDate, SOH.SalesPersonID 
ORDER BY SOH.OrderDate DESC,  P.FirstName +' '+P.LastName