title: Why can't I use alias in a count(*) "column" and reference it in a having clause?
body: <p>I was wondering why can't I use alias in a count(*) and reference it in the having clause. For instance:</p>
  
  <pre><code>select Store_id as StoreId, count(*) as _count
      from StoreProduct
      group by Store_id
          having _count &gt; 0
  </code></pre>
  
  <p>Wouldn't work.. But it works if I remove _count and use count(*) instead.</p>