title: How return a count(*) of 0 instead of NULL
body: <p>I have this bit of code:</p>
  
  <pre><code>SELECT Project, Financial_Year, COUNT(*) AS HighRiskCount
  INTO #HighRisk 
  FROM #TempRisk1
  WHERE Risk_1 = 3
  GROUP BY Project, Financial_Year
  </code></pre>
  
  <p>where it's not returning any rows when the count is zero. How do I make these rows appear with the HighRiskCount set as 0?</p>