Microsoft
70-457 · Question #79
You are a database developer for an application hosted on a Microsoft SQL Server 2012 server. The database contains two tables that have the following definitions: Global customers place orders from…
The correct answer is A. Option A. See the full explanation below for the reasoning.
Question
You are a database developer for an application hosted on a Microsoft SQL Server 2012 server. The database contains two tables that have the following definitions:
Global customers place orders from several countries. You need to view the country from which each customer has placed the most orders. Which Transact-SQL query do you use?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(43 responses)- A77% (33)
- B12% (5)
- C5% (2)
- D7% (3)
Community Discussion
No community discussion yet for this question.

