title: how to get previous year (month december) and month showing current month in sql
body: <p>I have list of datetime value. How to select previous year just for december only. </p>
  
  <p>For example: </p>
  
  <pre><code>Current month = May 2016
  Previous year of december = Dec 2015
  (it will display data from dec 2015 to may 2016)
  
  if Current month = May 2017
  Previous year of december = Dec 2016 and so on.
  (it will display data from dec 2015 to may 2016)
  </code></pre>
  
  <p>Any idea ? Thank you very much</p>