title: MYSQL count of count?
body: <p>I have a mysql table like:</p>
  <pre><code>id, visitorid, pageid
  </code></pre>
  <p>When a visitor hits the website it stores their visitor id and the page id as a row.</p>
  <p>I am trying to extract the number of visitors who hit the website exactly X times. (for a chart). so how many visit just one page, how many visit 2 pages...</p>
  <p>so far I have:</p>
  <pre><code>SELECT COUNT(visid),visid FROM vislog GROUP BY visid ORDER BY COUNT(visid) DESC
  </code></pre>
  <p>But I don't know how to do the next part of counting the counts.</p>
  <p>Is it possible to do as a MySQL query?</p>