title: SQLite: How do I find the daily/weekly/monthly/yearly average of a row count
body: <p>I've just started learning SQLite, and had a question.</p>
  
  <p>Here is an example of what I mean.</p>
  
  <p>This is my CSV:</p>
  
  <pre><code>date
  2010-10-24
  2010-10-31
  2010-11-01
  2011-02-14
  2011-02-15
  2011-02-16
  2011-10-01
  2012-01-15
  2012-05-12
  2012-05-14
  2012-08-12
  2012-08-26
  </code></pre>
  
  <p><br></p>
  
  <p>My code: </p>
  
  <pre><code>SELECT STRFTIME('%Y-%m', date) AS 'month', COUNT() AS 'month_count'
      FROM tableName 
      GROUP BY STRFTIME('%Y-%m', date);
  </code></pre>
  
  <p><br>
  The result (in comma-delimited form):</p>
  
  <pre><code>month, month_count
  2010-10, 2
  2010-11, 1
  2011-02, 3
  2011-10, 1
  2012-01, 1
  2012-05, 2
  2012-08, 2
  </code></pre>
  
  <p><br>
  What I'm looking for now, is a way to get the average number of 'month_count' per month, which is of course different from just the average of 'month_count'. That is, the former equals 0.55, while the latter equals 1.71, and I'm trying ti calculate the former.</p>
  
  <p>I tried using AVG(COUNT()), though that obviously made no logical sense.</p>
  
  <p>I'm guessing I'd have to store the code-generated table as a temporary file, then get the average from it, though I'm not sure how to properly write it.</p>
  
  <p>Does anyone know what I'm missing?</p>