title: Group and Count in SQL Server 2008
body: <p>OK I might be asking a stupid question, but I'm banging my head over this..</p>
  
  <p>Say I have a table like so:</p>
  
  <pre><code>FullName | DownloadDate
  -------- | -----------------------
  Jack     | 2012-03-21 00:00:00.000
  Joe      | 2012-03-21 00:00:00.000
  John     | 2012-03-22 00:00:00.000
  </code></pre>
  
  <p>I want to return the number of downloads by date so the resulting table is:</p>
  
  <pre><code>DownloadDate            | TotalDownloaded
  ------------------------| ---------------
  2012-03-21 00:00:00.000 | 2
  2012-03-22 00:00:00.000 | 1
  </code></pre>
  
  <p>How can I achieve this?</p>
  
  <p>Also, you can assume that in my date column in the original data, I will always have a time of '00:00:00.000'.</p>