Microsoft Exam 70-461 Topic 5 Question 4 Discussion

You develop a Microsoft SQL Server database. The database contains a table defined by the following

Transact-SQL statement:

All regions have more than one employee.

You need to write a query to find the employee with the highest SalesYTD in each region with the following result set:

* First Name

* Last Name

* Region

* Sales YTD

Which Transact-SQL query should you run?