title: Filtering grouped results on COUNT of a number of rows
body: <p>I basically have a very simple query like such</p>
  
  <pre><code>SELECT accounts . * , COUNT(receive) as total_counts
  FROM followings
  LEFT JOIN accounts ON followings.receive = accounts.account_id
  WHERE accounts.status &lt;1
  GROUP BY followings.receive
  ORDER BY COUNT(receive) DESC
  </code></pre>
  
  <p>I've tried changing it to the following and it's failing</p>
  
  <pre><code>SELECT accounts . * , COUNT(receive) as total_counts
  FROM followings
  LEFT JOIN accounts ON followings.receive = accounts.account_id
  WHERE accounts.status &lt;1
      AND total_accounts &lt; 10
  GROUP BY followings.receive
  ORDER BY COUNT(receive) DESC
  </code></pre>
  
  <p><code>Unknown column 'total_counts' in 'where clause'</code></p>
  
  <p>I'm sorry for posting such simple question, but my mind is boggling right now</p>