title: How to do running sum with group by in SQL?
body: <p>Now I have a table like as follows </p>
  
  <pre><code>    Date        Promotion campaign    Visit      Orders    Revenue
     2018-06-01    Promotion01           200         5       1000
     2018-06-01    Promotion02           250         10      1100
     2018-06-02    Promotion01           220         8       1350
     2018-06-03    Promotion03           300         15      2000  
      ...
  </code></pre>
  
  <p>And I would like to generate a table that shows the cumulative figures like </p>
  
  <pre><code>    Date         Visit        Orders       Revenue  
    2018-06-01      450           15           2100
    2018-06-02      670           23           3450
    2018-06-03      970           38           5450 
  </code></pre>
  
  <p>I know first I may have to use the group by function and group the data by date, and afterwards how can I make the running sum for 3 columns? </p>
  
  <p>The dw is amazon-redshift. Many thanks for your help in advance!</p>