title: SQL SUM Query Modification
body: <p>I have a SUM SQL query that is being used to display a chart in asp.net.</p>
  
  <p>It sums up the amount of quantities that have the same value for example:</p>
  
  <pre><code>   Quantity|Total
     --------|-----
         1   | 5
         2   | 10
         3   | 12
         4   | 16
         5   | 5
         6   | 8
  </code></pre>
  
  <p>Basicaly, there are 5 orders where quantity = 1, there are 10 orders where quantity = 2 and so on.</p>
  
  <pre><code> SELECT        Quantity, SUM(Quantity) AS Total
   FROM            orders
   GROUP BY Quantity
  </code></pre>
  
  <p>Thats my code for that.</p>
  
  <p>I wanna know how i can make the query so i get this result.</p>
  
  <pre><code>   Quantity|Total
     --------|-----
         1   | 5
         2   | 10
         3   | 12
         4   | 16
         5   | 5
         6   | 8
         6+  | 5
  </code></pre>
  
  <p>So every order that has quantity over 6, they should be added together and displayed like 
                         <strong>6+  | 5</strong>.</p>