title: List the name(s) of professor(s) whose average teaching rating is the highest
body: <p>I got tables such:
  Teaches(<strong>cid,year,pid</strong>,rating)
  Professor(<strong>pid</strong>,name)</p>
  
  <p>I compose a query like this(hopely it gives me all profs with ratings, but not the highest):</p>
  
  <pre><code>SELECT P.name, T.rating
  FROM Teaches T, Professor P
  GROUP BY T.pid
  HAVING AVG(rating)
  </code></pre>
  
  <p>How I can embed query like give me rows containing highest rating(s) into this query?</p>