title: DISPLAY MIN() and MAX() Values in MySQL
body: <p>I have a table called <strong>cia</strong> with 2 columns:</p>
  
  <p>Column 1 (<strong>'Name'</strong>) has the names of all countries in the world. 
  Column 2 (<strong>'area'</strong>)has the size of those countries in m^2. </p>
  
  <p>I want to find the biggest and smallest country. To find those I need to enter the following Queries:</p>
  
  <pre><code>SELECT Name, MAX(area) FROM cia
  </code></pre>
  
  <p>My other query:</p>
  
  <pre><code>SELECT Name, MIN(area) FROM cia
  </code></pre>
  
  <p>Now obviously I could do</p>
  
  <pre><code>SELECT MIN(area), MAX(area) FROM cia
  </code></pre>
  
  <p>however, I wouldn't get the corresponding name to my values then. Is it possible to get an output like this</p>
  
  <p><strong>Country     | Fläche</strong></p>
  
  <p>Afghanistan | lowest value of column 'area'</p>
  
  <p>China        | highest value of column 'area'</p>