title: SQL Server Group By Last 24 Hours, Last 7 Days and Last 14 Days
body: <p>I need to write an SQL query to produce the following result set. What's the best way to achieve this?</p>
  
  <pre><code>Time Range          Qty                Amount
  ===============================================
  Last 24 Hours       56                 $2000
  Last 7 Days         359                $3900
  Last 14 Days        2321               $22,888
  </code></pre>