1. Compute the FROM and WHERE clauses.

2. Group by the attributes in the GROUPBY

3. Select one tuple for every group (and apply aggregation)

SELECT can have (1) grouped attributes or (2) aggregates.