title: How to have GROUP BY and COUNT include zero sums?
body: <p>I have SQL like this (where <code>$ytoday</code> is 5 days ago):</p>
  
  <pre><code>$sql = 'SELECT Count(*), created_at FROM People WHERE created_at &gt;= "'. $ytoday .'" AND GROUP BY DATE(created_at)';
  </code></pre>
  
  <p>I want this to return a value for every day, so it would return 5 results in this case (5 days ago until today).</p>
  
  <p>But say <code>Count(*)</code> is 0 for yesterday, instead of returning a zero it doesn't return any data at all for that date.</p>
  
  <p>How can I change that SQLite query so it also returns data that has a count of 0?</p>