title: Select data on current week between Monday to Sunday
body: <p>I've query to select data for interval one week (&lt;7 from current day)</p>
  
  <pre><code>SELECT order_date 
  FROM sales 
  WHERE order_date &gt;= DATE_SUB(CURDATE(), INTERVAL 1 WEEK);
  </code></pre>
  
  <p>Further I want to select data from table on current week between Monday to Sunday. How is the proper <code>where</code> condition to grab that data?</p>