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?

SELECT c.CustomerID, c.CustomerName, o.ShippingCountry 

FROM Customer c 

INNER JOIN 

(SELECT CustomerID, ShippingCountry, 

RANK() OVER (PARTITION BY CustomerID 

ORDER BY COUNT(OrderAmount) DESC) AS Rnk 

FROM Orders 

GROUP BY CustomerID, ShippingCountry) AS o 

ON c.CustomerID = o.CustomerID 

WHERE o.Rnk = 1

it can either be 2. or 4. : ) tell me if i'm wrong or right