Aggregate functions

An aggregate function computes a single result from multiple input rows.

For example, you can use aggregates to compute the count, sum, avg (average), max (maximum), median (middle), and min (minimum) over a set of rows.

There are two main categories of aggregate functions: grouped and window aggregates.