title: SQL: Add the row values and display in new column
body: <p>I Have table t1 ordered by tasteRating</p>
  
  <pre><code>    Fruit | tasteRating|Cost 
      -----------------------
      Apple |  99       | 1  
      Banana|  87       | 2  
      Cherry|  63       | 5 
  </code></pre>
  
  <p>I want t2</p>
  
  <pre><code>    Fruit | Cost | Total Cost
      -------------------------
      Apple |   1  | 1
      Banana|   2  | 3
      Cherry|   5  | 8
  </code></pre>
  
  <p>Is there a way to generate Total Cost dynamically in SQL based on value of Cost?
  Doing this on Redshift.
  Thanks</p>