title: How to group data into buckets in Microsoft SQL
body: <p>Currently my SQL statement is the following</p>
  
  <pre><code>SELECT NAME, ROUND([DR# BASE]/DAYS_WORKED,0) AS 'BASE/DAY'
  FROM MYTABLE
  </code></pre>
  
  <p>And the output data looks like the following</p>
  
  <pre><code>NAME    BASE/DAY
  James   300
  Jane    310
  Jim 313
  John    325
  Jonah   400
  </code></pre>
  
  <p>Is there a SQL statement to make the Output look like the following? </p>
  
  <pre><code>NAME    BUCKET  BASE/DAY
  James   300 &lt;= 325  300
  Jane    300 &lt;= 325  310
  Jim 300 &lt;= 325  313
  John    300 &lt;= 325  325
  Johnny  325 &lt;= 350  329
  Jonah   350 &lt;= 400  400
  </code></pre>