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

-- left outer join between two tables
-- windowed aggregate on column from the left side
-- windowed aggregate on column from the right side
-- 2 different windows
select
        j2.c_boolean,
        j2.c_date,
        j2.c_integer,
        sum(j1.c_integer) over (partition by j1.c_boolean order by j1.c_date, j1.c_integer),
        avg(j2.c_integer) over (partition by j2.c_boolean order by j2.c_date, j2.c_integer),
        sum(j1.c_integer) over (partition by j1.c_date ,j1.c_date, j1.c_bigint),
        avg(j2.c_integer) over (partition by j2.c_date ,j2.c_date, j2.c_bigint)
from    j1
           left outer join
        j2 on j1.c_integer = j2.c_integer
order by 1,2,3;