Grouping and Aggregates
Rows may be grouped based on attribute values
- Think of it as a sort on those attributes
Aggregate functions can be applied to the grouped relation
- Computes a value for each group
Result returned as a relation with:
- one row for each group (unique value),
- one column for each aggregate function