country where transactions have occurred, they need to know the merchant with the highest number of transactions. If multiple merchants are tied for the highest count in a country, include all of them.Return
country: the transaction countrymerchant_id: the merchant's IDname: the merchant's nametxn_count: the number of transactions for this merchant in that country
Rows should be ordered by country ascending, then merchant_id ascending.Expected output
| country | merchant_id | name | txn_count |
|---|---|---|---|
| AE | 9 | Emirates | 1 |
| GB | 14 | Tesco | 2 |
| IN | 1 | Whole Foods Market | 1 |
First 3 of 14 rows your query should return. Your column aliases don't need to match.