title: MySQL group by with multiple column sums and a total sum for each group
body: <p>I have a table like this:</p>
  
  <pre><code>Votes (id, person, positive_vote, negative_vote)
  </code></pre>
  
  <p>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).</p>
  
  <p>Here's what I have so far:</p>
  
  <pre><code>SELECT person, sum(positive_vote), sum(negative_vote) FROM Votes GROUP BY person;
  </code></pre>