title: SQL; Only count the values specified in each column
body: <p>In SQL I have a column called "answer", and the value can either be 1 or 2. I need to generate an SQL query which counts the number of 1's and 2's for each month. I have the following query, but it does not work:</p>
  
  <pre><code>SELECT MONTH(`date`), YEAR(`date`),COUNT(`answer`=1) as yes,
  COUNT(`answer`=2) as nope,` COUNT(*) as total
  
  FROM results
  
  GROUP BY YEAR(`date`), MONTH(`date`)
  </code></pre>