title: Selecting all records from one year ago till now
body: <p>I have a table filled with a lot of rows and I need to select all the rows that are less than a year old till now.</p>
  
  <p>The table (called <code>orders</code>) has a <code>DateTime</code> column named <code>order_date</code>, that's the field that determines when the order was placed. </p>
  
  <p><strong>How can I select all the records that have an <code>order_date</code> between now and a full year ago?</strong></p>