title: SQL select count case comparing 2 columns
body: <p>I'm breaking my head over a SQL statement comparing 2 columns and when they are not similar the statement should add 1 to the count. </p>
  
  <p>Here is my code.</p>
  
  <pre><code>SELECT 
      COUNT(*) CASE WHEN Column1 = Column2 THEN '0' ELSE '1' END AS result 
  FROM [Sheet1$] 
  GROUP BY Column1
  </code></pre>
  
  <p>What am I doing wrong? I get the error message of a missing operator in the query expression.</p>