title: SQL Statement to get daily totals
body: <p>I'm storing some data in a table and I want to be able to display the total data points <strong><em>per day</em></strong> on the graph. So the first graph point might be 7 for Monday, Jan 1, 2013, and then 3 for Tuesday, Jan 2, 2013...etc.</p>
  
  <p>I have full time/date stamps for each of my data points in my table of SQL type <em>datetime</em>.</p>
  
  <p>My pseudo statement looks like this, but I'm concerned since I'm using the <em>datetime</em> data type:</p>
  
  <pre><code>SELECT 
      DATE(created_at) AS create_date
      COUNT(id) AS total
  FROM
      data_table
  GROUP BY 
      create_date
  </code></pre>
  
  <p>How can I get the total data points per day, regardless of the timestamp?</p>