title: How to run a query to get results of last 12 months ( BigQuery)
body: <p>I want to get records for last 12 months for a particular ID in Big Query table. I have extracted month and year as separate columns from the original timestamp column. I tried using date_add() and date_diff() but i am getting some errors. My Dataset is like:</p>
  
  <pre><code>Month Year MonthName    ID
  8     2018   August      1
  9     2018   September   2
  9     2017   September   3
  </code></pre>
  
  <p>How can i achieve this?</p>