title: Django equivalent of COUNT with GROUP BY
body: <p>I know Django 1.1 has some new aggregation methods. However I couldn't figure out equivalent of the following query:</p>
  
  <pre><code>SELECT player_type, COUNT(*) FROM players GROUP BY player_type;
  </code></pre>
  
  <p>Is it possible with Django 1.1's Model Query API or should I just use plain SQL?</p>