Aggregate calculations
1.1 Statistical functions The statistical functions are standard to SQL and allow the calculation of statistical results on the rows of a table. AVG (column) Average values SUM (column) Sum of values MIN (column) Minimum value MAX (column) Maximum value COUNT (column) Number of values in the column COUNT (DISTINCT…