title: Is it possible to get the sum of overall_score in this query?
body: <p>So I have a table of links , and a table of votes for those links. So for instance, link google.co.uk has one record in the links table, and then it could have four vote records in the votes table, each with a score of -1 , 1 or 2 . I have done this query which sums the votes for each link, but is it possible to sum all the scores for all the links in the same query, so the user has a score?</p>
  
  <pre><code>SELECT *, SUM(v.vote_score) AS overall_score 
  FROM mdl_link_critic_links l 
      JOIN mdl_link_critic_votes v on l.id = v.link_id 
  WHERE l.user_id = '3' 
  GROUP BY l.id
  </code></pre>
  
  <p>results are like</p>
  
  <pre><code>google.co.uk, user_id 3, overall_score 3
  ebay.co.uk , user_id 3, overall_score 4
  stackoverflow.com, user_id, 3, overall_score 10
  </code></pre>
  
  <p>and I would like to sum all the overall scores , so in this case, it would be 17</p>