title: Listing based on a particular SQL Group
body: <p>How can I list the names of all countries whose surface Area is greater than that of all other countries in the same region from the country Table below:</p>
  
  <pre><code>+----------------------------------------------+---------------------------+-------------+
  | name                                         | region                    | surfacearea |
  +----------------------------------------------+---------------------------+-------------+
  | Aruba                                        | Caribbean                 |      193.00 |
  | Afghanistan                                  | Southern and Central Asia |   652090.00 |
  | Angola                                       | Central Africa            |  1246700.00 |
  | Anguilla                                     | Caribbean                 |       96.00 |
  | Albania                                      | Southern Europe           |    28748.00 |
  | Andorra                                      | Southern Europe           |      468.00 |
  | Netherlands Antilles                         | Caribbean                 |      800.00 |
  </code></pre>
  
  <p>So far I have come with this code but this does not list the countries ? Is this code correct ?</p>
  
  <pre><code>select region, max(surfacearea) as maxArea 
  from country 
  group by region; 
  </code></pre>