title: Using sample "world" database to find country with most cities
body: <p>I'm currently learning mySQL. I have noticed that mySQL comes with a "world" database that contains a database of cities from around the world with their respective countries and populations.</p>
  
  <p>I am interested in finding the top 5 countries with the <em>most</em> cities using this database (<strong>city</strong> is the name of the table), and this is the query I use:</p>
  
  <pre><code>use world;
  
  select `Name`,count(*) 
  from  `city` 
  group by `Name` 
  order by count(*) desc 
  limit 5;
  </code></pre>
  
  <p>Is this correct? I am having doubts because for some reason, when I remove the count(*) column, I get different results.</p>
  
  <p>Thanks!</p>