Window

cum_sum	The sum of all preceding elements and the current element.
shift	Shifts values in the column by an offset.

dense_rank	The number of smaller or equal values in the column (not counting duplicates).
rank	The number of strictly smaller elements in the column plus one.
row_number	Computes the index of a row.