title: MySQL - SELECT the name that comes first alphabetically
body: <p>I have started to learn MySQL. </p>
  
  <p>Here is the table <code>world</code>:</p>
  
  <pre><code>+-------------+-----------+---------+
  |    name     | continent |  area   |
  +-------------+-----------+---------+
  | Afghanistan | Asia      | 652230  |
  | Albania     | Europe    | 2831741 |
  | Algeria     | Africa    | 28748   |
  | ...         | ...       | ...     |
  +-------------+-----------+---------+
  </code></pre>
  
  <p>I need: </p>
  
  <blockquote>
    <p>List each continent and the name of the country that comes first alphabetically</p>
  </blockquote>
  
  <p>The result of SELECT must be:</p>
  
  <pre><code>+---------------+---------------------+
  |   continent   |         name        |
  +---------------+---------------------+
  | Africa        | Algeria             |
  | Asia          | Afghanistan         |
  | Caribbean     | Antigua and Barbuda |
  | Eurasia       | Armenia             |
  | Europe        | Albania             |
  | North America | Belize              |
  | Oceania       | Australia           |
  | South America | Argentina           |
  +---------------+---------------------+
  </code></pre>