title: For each country, find city that has the highest population and the city's population
body: <p>I am using the Mondial database schema and am trying to find: For each country, find city that has the highest population and the city's population.</p>
  
  <p>Right now I have:</p>
  
  <pre><code>SELECT Country.Name, city.name, MAX(city.population) Population
  FROM city
  Join Country
  On Country.Code=City.Country
  WHERE city.population IS NOT NULL
  GROUP BY Country.Name, city.name
  ORDER BY Country.Name;
  </code></pre>
  
  <p>This gives me <strong>ALL</strong> of the cities in each country and their populations and not just the largest city.</p>