title: Getting all orders, where the last order ist older than a year in mySql
body: <p>I have a mySQL table, which holds:
  CustomerId and OrderDate</p>
  
  <p>There can me multiple rows for one CustomerId
  Now, I try to get the CustomerId's where only the last OrderDate is older than a year.
  I try the following:</p>
  
  <pre><code>SELECT * 
  FROM order 
  WHERE OrderDate &lt;=DATE_SUB(now(), Interval 1 Year) 
  GROUP BY CustomerId 
  ORDER BY OrderDate DESCC;
  </code></pre>
  
  <p>The problem here is, that I get all the rows, which are older then 1 year.
  But as I said above, I try to get only the latest order, which is older than 1 year.
  THX for any advise</p>