SQL Server question from Northwind Database:

Create a query for:

Using the orders table, returning a ranking of the top number of orders per ship country. At a minimum, include the ShipCountry, the ranking, and the order count. If there is a tie in the ranking, skip to the next number (e.g. 2 countries are ranked forth, the next country should have a ranking of five)