SQL SUM

SUM function allows for the total sum of the values of a numeric column.

SQL Syntax SUM

SELECT SUM (column) FROM table

Given the following table 'orders'

idorderclientprice
1p1HARRY100
2p2CLARK300
3p3SMITH250
4p4BROWN490
5p5WHITE60

SELECT SUM (price) FROM orders

Return the value 1200, which is the sum of all column values 'price' in the query made in this case, the entire table.