title: MySQL: Return fields where COUNT(*) is greater than
body: <p>I've got the following SQL, but I only want to return rows where 'hits' are greater than 10.</p>
  
  <pre><code>SELECT clicks.affiliate, COUNT(*) AS hits, affiliates.title, affiliates.url
  FROM clicks
  INNER JOIN affiliates ON affiliates.id = clicks.affiliate
  GROUP BY clicks.affiliate
  </code></pre>
  
  <p>Thanks.</p>