title: Find the MAX value of an Aggregate Query In SQL Server 2008:  SELECT the U.S. State with the Most Cities
body: <p>Ok expert SQL Devs, I hope this is as simple as it sounds.  Basically I want to form a query to find the number of cities per state <strong>AND</strong> only contain the State with the most cities in the result set.</p>
  
  <p>Something like:</p>
  
  <pre><code>SELECT S.Name, MAX(COUNT(C.StateID) as 'Count') --NO Can do, please help!
  FROM tblStates as S JOIN tblCities as C
  ON S.StateID = C.StateID
  GROUP BY S.Name
  </code></pre>
  
  <p>Please let me know the easiest way to make this Query work.</p>
  
  <p>Thanks</p>