title: Counting consecutive days for all items in SQL
body: <p>I'm trying to count consecutive days for all items. I've found how to count consecutive days <a href="https://stackoverflow.com/questions/25272098/mysql-count-consecutive-dates-for-current-streak">just for one item</a>, sample data</p>
  <pre><code>bob 2014-08-10 00:35:22
  sue 2014-08-10 00:35:22
  bob 2014-08-11 00:35:22
  mike 2014-08-11 00:35:22
  bob 2014-08-12 00:35:22
  mike 2014-08-12 00:35:22
  </code></pre>
  <p>would give me result for Bob like this:</p>
  <pre><code>date_created         | streak|
  2014-08-10 00:35:22  |      3|
  </code></pre>
  <p>But I'd need to get it for all users like this:</p>
  <pre><code>date_created         | streak|username
  2014-08-10 00:35:22  |      3|     Bob
  2014-08-11 00:35:22  |      2|     Mike
  </code></pre>
  <p>I've been trying to modify sql from <a href="https://stackoverflow.com/a/25273033/873453">this response</a>, but I just can not get it work. I'd be thankful for any advice.</p>