title: Nesting Aggregate Functions - SQL
body: <p>I want to make a SQL query which finds the catagory of awards for movies which has the highest average rating, so for a group of movies which have won a particular award, if they have a higher average rating than any other awards group of movies then it will be returned.</p>
  
  <p>I tried something like this:</p>
  
  <pre><code>SELECT MAX(AVG(m."Rating"))
  FROM awards a, movies m
  WHERE a."Title" = m."Title"
  GROUP BY a."Award"
  </code></pre>
  
  <p>but it seems that aggregate functions cannot be nested. How can I call the max function on the average ratings for each catagory?</p>