Per player, per post, per country
A leaderboard needs a total for each player, not one total for everyone. GROUP BY splits the rows into groups and runs your aggregate once per group.
A leaderboard needs a total for each player, not one total for everyone. GROUP BY splits the rows into groups and runs your aggregate once per group.