title: Running total sum over date presto SQL
body: <p>I'm trying to calculate the cumulative sum of columns t and s over a date from my sample data below, using Presto SQL. </p>
  
  <pre><code>Date   | T | S 
  1/2/19 | 2 | 5
  2/1/19 | 5 | 1
  3/1/19 | 1 | 1
  </code></pre>
  
  <p>I would like to get </p>
  
  <pre><code>Date   | T | S | cum_T | cum_S 
  1/2/19 | 2 | 5 |    2  |  5 
  2/1/19 | 5 | 1 |    7  |  6
  3/1/19 | 1 | 1 |    8  |  7
  </code></pre>
  
  <p>However when I run the below query using Presto SQL I am receiving an unexpected error message, telling me to put columns T and S into the group by section of my query.  </p>
  
  <p>Is this expected? When I remove the group by from my query it runs without error, but produces duplicate date rows. +</p>
  
  <pre><code>select
    date_trunc('day',tb1.date),
    sum(tb1.S) over (partition by date_trunc('day',tb1.date) order by date_trunc('day',tb1.date) rows unbounded preceding )  as cum_S,
    sum(tb1.T) over (partition by date_trunc('day',tb1.date) order by date_trunc('day',tb1.date) rows unbounded preceding)  as cum_T
  from esi_dpd_bi_esds_prst.points_tb1_use_dedup_18months_vw tb1
  where 
    tb1.reason_id not in (45,264,418,983,990,997,999,1574)
    and tb1.group_id not in (22)
    and tb1.point_status not in (3)
    and tb1.date between cast(DATE '2019-01-01' as date) and cast( DATE '2019-01-03' as date)
  group by 
      1
  order by date_trunc('day',tb1.date) desc 
  </code></pre>
  
  <p>Error looks like this:</p>
  
  <pre><code>Error: line 3:1: '"sum"(tb1.S) OVER (PARTITION BY "date_trunc"('day', tb1.tb1) ORDER BY "date_trunc"('day', tb1.tb1) ASC ROWS UNBOUNDED PRECEDING)' must be an aggregate expression or appear in GROUP BY clause.
  </code></pre>