GROUP BY & ORDER BY with SQLite
Aggregating is creating a total form a number of records. Sum, min, max, count, and aggregate are common aggregate operations.
In SQL we group these totals on a any column, allowing you to control the scope of these aggregations.