Aggregate Functions: These are functions that operate against a collection of values, but return a single value. Scalar Functions: These functions operate against a single value, and return a single ...