blob: 68c8cf3d6a61a3a491e7cb3d738e1731f09cb5db [file] [log] [blame]
select
sum(c_integer + 100) over (partition by c_boolean order by c_date),
sum(c_integer - 100) over (partition by c_date),
avg(c_integer - 1000) over (partition by c_boolean order by c_date),
avg(c_integer - 1000) over (partition by c_date),
avg(c_integer) over(),
row_number() over(order by c_date)
from
j2;