How to sum all values of a column in Mysql?

Question

How do I add all user points? For example:

ID | NOME  |  PONTOS
 1 | Joao  |   100
 2 | Bia   |    50 

It is known that the sum of all the points in the database is 150.

Answer 1

How to do

Summing up:

SELECT SUM(PONTOS) AS total 
FROM tabela

Adding up by users:

SELECT NOME, SUM(PONTOS) AS total 
FROM tabela
GROUP BY NOME

Counting the amount of records per user:

SELECT NOME, COUNT(PONTOS) AS registros
FROM tabela
GROUP BY NOME

Displaying the average per user:

SELECT NOME, AVG(PONTOS) AS media
FROM tabela
GROUP BY NOME

All up together:

SELECT NOME, SUM(PONTOS) AS total, COUNT(PONTOS) AS registros, AVG(PONTOS) AS media
FROM tabela
GROUP BY NOME

---

See working on Sqlfiddle

---

References

COUNT, SUM, AVG

GROUP BY

DISTINCT and GROUP BY, what is the difference between the two statements?