Using GROUP BY with aggregate functions

A GROUP BY clause almost always appears in statements that include aggregate functions, in which case the aggregate produces a value for each group. These values are called vector aggregates. (A scalar aggregate is a single value produced by an aggregate function without a GROUP BY clause.)

 Example