title: GROUP BY WEEK with SQL
body: <p>I have the following: </p>
  
  <p><a href="http://sqlfiddle.com/#!6/226ae/1" rel="noreferrer">http://sqlfiddle.com/#!6/226ae/1</a></p>
  
  <p>I'm trying to now add one row for each week of the year, and filter the contacts accordingly.  CONTACTS has a datetime column.  The new table will look like: </p>
  
  <pre><code>        Status 1    Status 2    Status 3
  Week 1      3          4           2
  Week 2      1          5           3
  Week 3      2          2           4
  </code></pre>
  
  <p>I think that DATEADD needs to be used, however I'm at a loss in terms of how to begin changing my query.  </p>
  
  <p>I do know that MySQL has a GROUP BY WEEK command, but I don't think that SQL has an equivalent.  What's the best way to accomplish this? </p>