title: Grouping rows from a single day into a count - MYSQL
body: <p>I've been trying to work through this problem for a bit, and clearly I'm missing something (probably something obvious).</p>
  
  <p>I'm trying to group rows from a single day into a count. So the output should look like this:</p>
  
  <pre><code>Date         Count
  2009-09-12   2
  2009-09-13   5
  2010-01-09   4
  </code></pre>
  
  <p>...and so on.</p>
  
  <p>My current SQL looks like this:</p>
  
  <pre><code>SELECT `date`, COUNT(*) FROM `sales_flat_table` GROUP BY `date`;
  </code></pre>
  
  <p>And outputs data that looks like this: </p>
  
  <pre><code>Date        Count
  2009-09-12  1
  2009-09-12  1
  2009-09-13  1
  2009-09-13  1
  2009-09-13  1
  2009-09-13  1
  2009-09-13  1
  </code></pre>
  
  <p>...and so on.</p>
  
  <p>What am I missing? Thanks!</p>