title: sql query to return top 10 count of countries
body: <p>I have a MySQL table that has '<strong>id</strong>' and '<strong>country</strong>' as it's columns (there is other stuff too, but that relevant). </p>
  
  <p>In this table I have lots of incrementing id's and lots of different country names such as '<strong>United Kingdom</strong>', '<strong>Hungary</strong>' &amp;  '<strong>United States</strong>'.</p>
  
  <p>I'm looking for some help for a query that will return the top 10 countries and a count of them in order (descending if possible)</p>
  
  <p>For example if '<strong>Hungary</strong>' appeared 100 times, '<strong>United States</strong>' 50 times and '<strong>United Kingdom</strong>' 25 times, then this would return:</p>
  
  <pre><code>'Hungary', 100
  'United States', 50
  'United Kingdom', 25
  </code></pre>
  
  <p>Does that make sense?</p>
  
  <p>Many thanks,</p>
  
  <p>Matt</p>