title: SQL query that displays "time ago dates" like “one week ago”, “two weeks ago”, “one month ago”, “one year ago”, etc
body: <p>I need a query that displays dates in the following format:</p>
  
  <p>Dates that fall in the past 7 days -> “one week ago”
  Dates that fall in the past 7 to 14 days -> “two week ago”
  Etc…</p>
  
  <p>Dates that fall in the past 30 days -> “one month ago”
  Dates that follow in the past 30 to 60 days -> “two months ago
  Etc..</p>
  
  <p>Dates that fall in the past 365 days -> “one year ago”
  Dates that fall in the past 365 to 730 days -> “two years ago
  Etc...</p>
  
  <p>If you guys can point me to the right direction I’ll appreciate it.</p>
  
  <p>Thank you</p>