framework/resources/Functional/window_functions/multiple_partitions/q19.sql

-- two different window clauses with GROUP BY 
-- aggregate function, windowed aggregate, row_number()
-- only order by clause in window definition
select 
	sum(c_integer),
        row_number()   over (order by c_date),
        sum(c_integer) over (order by c_date desc)
from 	
	j1 
group by 
	c_integer,
	c_date
order by
	row_number()   over (order by c_date)
;