title: Find the 5 most popular values mysql
body: <p>i have a database column called 'country_name' where it takes the country names of my shop buyers. How can i get the 5 most popular country names order by the frequency of appearing in my db? MOST POPULAR for me is how often that country names appears in my database. for example if i have the countries below:</p>
  
  <pre><code>Brazil
  Nigeria
  Nigeria
  Chile
  Chile
  Chile
  Norway
  Italy  
  </code></pre>
  
  <p>i want to get 1.Chile (cause it appears 3 times), 2.Nigeria (2 times), 3.Norway (1 time), 4.Italy, 5.Brazil</p>