Adding all values from output SQL

Question

So, i have a query which looks like this:

SELECT sum(distinct 101-players.position) as points from players
INNER JOIN clubs ON players.id_club=clubs.id_club 
GROUP BY clubs.club
ORDER BY points desc LIMIT 10  OFFSET 10;

And it gives me back:

Is there any way that this query will give me back added value? Just number 860.

Kindly please help me :/

(1) Tag with the database you are really using. (2) Explain how "860" is calculated. — Gordon Linoff, Jan 22 '21 at 14:49
@GordonLinoff 860 == sum of all numbers, so I guess it's just a plain sum without group by. — Shadow, Jan 22 '21 at 14:51
Does this answer your question? [MySql sum elements of a column](https://stackoverflow.com/questions/4586040/mysql-sum-elements-of-a-column) — Shadow, Jan 22 '21 at 14:52

score 0 · Accepted Answer · answered Jan 22 '21 at 15:02

You can just sum all the points you got from your query:

select sum(points) from (
SELECT sum(distinct 101-players.position) as points from players
INNER JOIN clubs ON players.id_club=clubs.id_club 
GROUP BY clubs.club
ORDER BY points desc LIMIT 10  OFFSET 10) t

Adding all values from output SQL

1 Answers1