SUM() - Cate Richter

The SUM () function performs the total sum (sum) of the defined records.

SELECT sum(column_name)
FROM table_name;

Example1:

We have a table Customer with this data:

CustomerID	Name	Hair	Salary
1	Alechandro	brown	100
2	Katerina	blonde	150
3	Lucie	blonde	30
4	Thomas	black	40
5	Theodor	black	120
6	Thomassino	black	99
7	Knor	brown	50
8	Thor	blonde	10
9	Lucie	pink	70

SELECT sum(salary)
FROM Customer;

The result is (100 + 150 + 3O + 40 + 120 + 99 + 50 + 10 + 70), that is “669”.

SUM(NAME)
669

I give people clear, functional, and proven instructions. I gently guide them so that they can fulfill their IT dreams.