Please create a query: The query should display the BusinessEntityID, salesperson FirstName and LastName (from the Person.Person table), and SalesYTD, grouped by BusinessEntityID, FirstName, and LastName, and sorted so that the highest SalesYTD appears at the top.

An example query is as follows:

SELECT S.ProductID,Name, FORMAT(SUM(LineTotal),'C')AsTotalSales FROM Sales.SalesOrderDetail S JOIN Production.Product P ON S.ProductID= P.ProductID GROUP BY S.ProductID,Name ORDER BY SUM(LineTotal) DESC;