How can I sum up the points of people by teams?

Question

MySQL

There are two tables:

Team ID	User IDs
one	15648984
one	345934851
2	894894564
2	43958346

User IDs	User Points
15648984	12
345934851	34
894894564	eight
43958346	6

Is it possible to write a query that will sum up users' scores by teams and display the sum of the team?

Team ID	Sum of points
one	46
2	fourteen

Answer 1

It can be so.

SELECT id as 'ID Команды', SUM(User_points) as 'Сумма очков' FROM comandTabl
LEFT JOIN userTabl ON comandTabl.id_user = userTabl.id
GroupBy id