title: How to group by week no and get start date and end date for the week number in Sqlite?
body: <p>I want to group the result by week no and get the start date and end date for the week. I had not idea on how to do this sqlite. Could somebody help me on this.</p>
  
  <p>I also really confiused the way sqlite works. Because if run the following query i get the week no as 00</p>
  
  <pre><code>SELECT strftime('%W','2012-01-01');
  </code></pre>
  
  <p>and week no as 01 instead of 00 for the following query</p>
  
  <pre><code>SELECT strftime('%W','2012-01-02');
  </code></pre>
  
  <p>Could somebody explain why the sqlite behaves like this.</p>