Functions Scalar functionsScalar functions transform a single value per row, grouped by the kind of data they work on.Aggregation functionsAggregation functions compute a value over a group of rows inside summarize.