title: MySQL Query to calculate Previous Week
body: <p>I would like to calculate my total order amount in the previous week.</p>
  
  <p>I got the query for getting the data for the last 7 days from the current date.</p>
  
  <pre><code>SELECT SUM(goods_total) AS Total_Amount  FROM orders
  WHERE order_placed_date &gt;= date_sub(current_date, INTERVAL 7 day);
  </code></pre>
  
  <p>Now how can I get Previous week data only, excluding this week.</p>
  
  <p>For e.g. This week I made $15,000 and last week i made $14,000.</p>
  
  <p>I get the $15,000 by running the above query.</p>
  
  <p>But i dont know how to calculate previous week. </p>