title: Highest Average in SQL Microsoft Access
body: <p>I have to write an SQL for the question "What is the song by the Stokes with the highest average rating?"
  I get stuck on the fact that I have to display the maximum average. I now have this: </p>
  
  <pre><code>SELECT STitle
  FROM Songs S, Like L, Perform P, Artists A
  WHERE S.SId=L.SId
  AND P.AId=A.AId
  AND S.SId=P.SId
  AND AName="The Stokes"
  AND Rating=(
  SELECT Max (Rating) as "Highest rating", AVG(Rating) as "average rating"
  FROM Songs S, Like L
  WHERE S.SId=L.SId
  Group BY S.SId, STitle);
  </code></pre>
  
  <p>I hope one of you can get it, cause I've been stuck on it for a while now. 
  Thanks everyone! :)</p>
  
  <p><a href="http://i.stack.imgur.com/yHhM1.jpg" rel="nofollow">The Tables</a></p>
  
  <p><a href="http://i.stack.imgur.com/7PT4m.jpg" rel="nofollow">The Error</a></p>