title: Sum all columns in a row
body: <p>How can I get a total results of all my rows? (for <strong>ORACLE</strong>)</p>
  
  <pre><code>SELECT
   NAME,
   SUM(CASE WHEN ASSIST_1 = 'YES' THEN 1 END) WEEK1,
   SUM(CASE WHEN ASSIST_2 = 'YES' THEN 1 END) WEEK2,
   SUM(CASE WHEN ASSIST_3 = 'YES' THEN 1 END) WEEK3,
  FROM TABLE_NAME
   WHERE GROUP BY NAME;
  </code></pre>
  
  <p>I have this results:
  Name week1 week2 week3</p>
  
  <pre><code>Anne    1 2 3
  Bob     3 1 0
  Charlie 4 5 1
  </code></pre>
  
  <p>I want this result:</p>
  
  <pre><code>Anne    1 2 3
  Bob     3 1 0
  Charlie 4 5 1
  Total   8 8 4
  </code></pre>