title: No records for given month in SQL COUNT and GROUP BY Month
body: <p>I have the following set of data:</p>
  
  <pre><code>ID  |  CREATED     |  USER
  --------------------------
  1   |  2012-01-14  |   XYZ
  2   |  2012-03-14  |   XYZ
  3   |  2012-03-15  |   XYZ
  4   |  2012-03-24  |   ABC
  5   |  2012-04-10  |   XYZ
  6   |  2012-04-11  |   ABC
  </code></pre>
  
  <p>And I need a report that shows the COUNT for a given user but also with a 0 for months where there are no records.</p>
  
  <pre><code>MTH  |  COUNT
  -------------
  JAN  |   1
  FEB  |   0
  MAR  |   2
  APR  |   1
  </code></pre>
  
  <p>I managed to get it to work but without the 0 for months with no records. So far, I have this syntax which is throwing an error..</p>
  
  <pre><code>SELECT Month(CREATED), COUNT(SELECT * FROM SEARCHES WHERE USER = 'XYZ')
  FROM SEARCHES
  GROUP BY Month(CREATED)
  </code></pre>