SELECT i, j, STD(i) OVER (ROWS UNBOUNDED PRECEDING) std, VARIANCE(j) OVER (ROWS UNBOUNDED PRECEDING) variance FROM w1;