aggregation queries sql code example

Example: sql aggregate functions

The following are the most commonly used SQL aggregate functions:
AVG – calculates the average of a set of values.
COUNT – counts rows in a specified table or view.
MIN – gets the minimum value in a set of values.
MAX – gets the maximum value in a set of values.
SUM – calculates the sum of values.

The following illustrates the syntax of an aggregate function:
aggregate_function_name(DISTINCT | ALL expression)

In this syntax;

First, specify the name of an aggregate function that you want to use such as AVG, SUM, and MAX.
Second, use DISTINCT if you want only distinct values are considered in the calculation or ALL if all values are considered in the calculation. By default, ALL is used if you don’t specify any modifier.
Third, the expression can be a column of a table or an expression that consists of multiple columns with arithmetic operators.