Microsoft Exam Questions

Which Transact-SQL query do you use?

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?

A.
Option A

B.
Option B

C.
Option C

D.
Option D