title: Limit SQL results to last 7 days
body: <p>I have a simple SQL query that looks like this...</p>
  
  <pre><code>SELECT 
      COUNT (* )
  AS
      count
  FROM
      wlead
  WHERE
      f_id = '765'
  </code></pre>
  
  <p>This works great but I would now like to limit the query to just return results from the last 7 days.  There is a field called date_created which is formatted like this...</p>
  
  <pre><code>2014-10-12 11:31:26
  </code></pre>
  
  <p>Is there an automatic way of limiting the results or do I need to work out the date 7 days previous first?</p>