Window Functions

Aggregate Functions (Used for calculations over a set of rows) SUM(): Calculates the sum of values over a window. AVG(): Calculates the average of values. MIN(): Finds the minimum value. MAX(): Finds the maximum value. COUNT(): Counts rows over ...