SUM

Sum() is an aggregate function that outputs the sum of all values in a specific column. We should keep in mind that this function can be used only on numerical columns, unlike count(), which can be used on any data type column.

The syntax of the sum() aggregate function looks like this:

1SELECT AVG(column)
2FROM table
3WHERE condition;