title: sum sql rows and add to a new column
body: <p>say i have this result to this query..</p>
  
  <pre><code>customername      p8    p12   p750   p1   m8
  customer1         5     48     4     4    4
  customer2         4            2     5    43
  customer3         4     -3     
  </code></pre>
  
  <p>now i want to ask if is there a way that i could add all the rows to form something like this:</p>
  
  <pre><code>customername      p8    p12   p750   p1   m8     total
  customer1         5     48     4     4    4       65
  customer2         4            2     5    43      54
  customer3         4     -3                        1
  </code></pre>
  
  <p>can anyone help me with this??   </p>