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

-- Arithmetic operation with two window functions
-- CAST function on top of windowed aggregate
select 
	c_date,
	c_time,
	c_integer,
	cast(count(*) over (partition by c_date ORDER BY c_time) as bigint)  + cast(sum(c_integer) OVER (partition by c_bigint order by c_time) as bigint) 
from 
	j6 
where 
	c_integer is not null;