| -- left outer join between two tables |
| -- windowed aggregate on column from the left side |
| -- windowed aggregate on column from the right side |
| -- 6 different windows: all types of supported default frames |
| 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), |
| count(j1.c_integer) over (), |
| count(j2.c_integer) over () |
| from j1 |
| left outer join |
| j2 on j1.c_integer = j2.c_integer |
| order by |
| 1,2,3; |
