Exam 70-461 topic 1 question 215 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?
A.

B.

C.

D.