title: filter last year from date sql teradata
body: <p>please I have a table that contains data from 2020-01-01 till 2021-02-01 and I need to select the data for the running last 12 months to be from 2021-02-01 Back to 2020-02-01 as an example. I need an optimized query as the table has a very huge amount of data 130Millions row</p>
  <p>thanks a lot.</p>