SELECT a, ROW_NUMBER() OVER (PARTITION BY b ORDER BY c) AS rn, SUM(a) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS running, LAG(a) OVER (PARTITION BY b ORDER BY c ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS prev FROM t