30 Aggregate functions
Aggregate functions takes a set of values as input and returns a single one as output.
Function | Definition |
---|---|
MIN | Smallest value |
MAX | Largest value |
COUNT | Number of rows |
SUM | Total value |
AVG | Average value |
30.1 Sqlite
TODO add them. https://www.sqlite.org/lang_aggfunc.html