title: Query to display zero it the sum of entries of the particular month is 0
body: <p>I'm preaty weak in sqlite queries .</p>
  
  <p>I have an set of entries in the sqlite database. I want to find the sum, grouped in months.</p>
  
  <pre><code>SELECT SUM(QUANTITY) quantity, strftime('%m', CREATED_ON) month FROM OrderItemBIT  WHERE (strftime('%Y%m',CREATED_ON) BETWEEN '201210' AND '201303') group by month
  </code></pre>
  
  <p>The problem is that if there is no entry for an particular month, I want that entry should display count as zero, but now its not showing anything.</p>
  
  <p>Ex. guess there no entry for the month of Jan for the above query. then it should display the Quantity as 0.</p>
  
  <p>Can anyone help to solve this problem!!!
  Thanks in Advance</p>