title: Active Users SQL query
body: <p>I'm trying to graph active users in a webapp. My database consists of two main tables, <code>user</code> and <code>task</code>. <code>task</code> has a <code>user_id</code>. </p>
  
  <p>My definition of <strong>active users:</strong> is <em>a user who has created more than 2 tasks within two weeks of a given end date</em>.</p>
  
  <p>So, I need an SQL query that gives me the number of active users between a given start and end date. I was able to do this by putting the query inside a loop, pulling the results each time, but I'd love to be able to do it in a single query.</p>
  
  <p>The returned data should be something like: </p>
  
  <pre><code>Date         Count
  2010-01-01   4
  2010-01-02   3
  2010-01-03   5
  </code></pre>
  
  <p>Edit to clarify desired dataset.</p>