title: Calling a column in relation to it's MAX attribute
body: <p>I've tried sorting through here and asking for help but so far I've got nothing..</p>
  
  <pre><code>$query = "
    SELECT 
      country.name,
      MAX(city.population) as max
    FROM 
      lab6.city,
      lab6.country
    WHERE city.country_code = country.country_code
    GROUP BY country.name
    ORDER BY max DESC";
  </code></pre>
  
  <p>This returns the max population of the most populated city in a country. What I need to do is return that city from the same table that the MAX city.population was found. So far I'm pretty sure I have to use a subquery but I've been playing with this thing for hours and can't solve it.</p>