MySQL group by with multiple column sums and a total sum for each group

Question

I have a table like this:

Votes (id, person, positive_vote, negative_vote)

I want to group by person and and sort by total votes for each person. I know how to get the total sum of a single column for a group, but I can't figure out how to get the total of all the sum for each group (the total votes).

Here's what I have so far:

SELECT person, sum(positive_vote), sum(negative_vote) FROM Votes GROUP BY person;

Answer 1

Try,

SELECT person, 
       sum(positive_vote) totalPositive, 
       sum(negative_vote) totalNegative,
       (sum(positive_vote) + sum(negative_vote)) totalVotes
FROM Votes 
GROUP BY person
-- HAVING (sum(positive_vote) + sum(negative_vote)) < 5