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

select 
	c_date,
	c_time,
	avg(c_integer) over(partition by c_date, c_time),
	avg(c_integer) over(partition by c_time order by c_date desc)
from
	j6;