title: MySQL: need assistance with MySQL logic
body: <p>I am trying to work through a MySQL problem and I almost have it... 
  The Question is... </p>
  
  <p><em>What query would you run to get all the cities in Mexico with a population of greater than 500,000? Arrange the result by population in descending order.</em></p>
  
  <p><strong><em>Here is the table I am working off of...</em></strong></p>
  
  <p><a href="https://i.stack.imgur.com/tWLXg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tWLXg.png" alt=""></a></p>
  
  <p><strong><em>My current code...</em></strong></p>
  
  <pre><code>SELECT cities.name, cities.population
  FROM countries
  LEFT JOIN cities
  ON countries.id = cities.country_id
  WHERE cities.population &lt; 500000
  </code></pre>
  
  <p>I feel like I should be super close. Any pointers?</p>