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

-- Mix of identical and different window clauses

select
	count(*) over (partition by c_date order by c_time) + sum(c_integer) over (partition by c_bigint order by c_time) as total1,
	count(*) over (partition by c_date order by c_time) + avg(c_integer) over() as total2,
	sum(c_integer) over (partition by c_date order by c_time) as total3,
	avg(c_integer) over (partition by c_date order by c_time) as total4
from j1;