title: not a single-group group function with MAX in select
body: <pre><code>Select sg_gameno, Max(sg_Year), sg_end, sg_hostcity, country_olympic_name
    from Summergames s, Country co
   where s.country_isocode = co.country_isocode 
  </code></pre>
  
  <p>Don't know whats wrong with this. I want to get the lastest year. Should i use MAX or something else.</p>