title: Want to force zero in group by clause
body: <p>Hi here is my simple query</p>
  
  <pre><code>--Code formatting
  select severity as measurement,
         count(tkts) as tkts
  from Maintable
  where (Bunch of conditions)
  group by severity
  </code></pre>
  
  <p>I am getting correct result but it is not showing the severity where result is 0, I want to force all severity even if they had zero tickets.</p>
  
  <p>Using SQL server 2012            </p>