title: Mysql: Calculate visit frequency
body: <p>I have this table</p>
  
  <pre><code>CREATE OR REPLACE TABLE hits (ip bigint, page VARCHAR(256), agent VARCHAR(1000), 
                                date datetime)
  </code></pre>
  
  <p>and I want to calculate googlebot visit frequency for every page.</p>
  
  <pre><code>... WHERE agent like '%Googlebot%' group by page
  </code></pre>