title: Select multiple sums with MySQL query and display them in separate columns
body: <p>Let's say I have a hypothetical table like so that records when some player in some game scores a point:</p>
  
  <pre><code>name   points
  ------------
  bob     10
  mike    03
  mike    04
  bob     06
  </code></pre>
  
  <p>How would I get the sum of each player's scores and display them side by side in one query?</p>
  
  <p><strong>Total Points Table</strong></p>
  
  <pre><code>bob   mike
  16     07
  </code></pre>
  
  <p>My (pseudo)-query is:</p>
  
  <pre><code>SELECT sum(points) as "Bob" WHERE name="bob",
         sum(points) as "Mike" WHERE name="mike"
    FROM score_table
  </code></pre>