title: Sqlite: Get total top ten score from multiple columns
body: <p>I have a table looking like:</p>
  
  <pre><code>ID    Task    Score
  1     4       2
  9     2       0
  7     6       1
  1     3       1
  9     1       2
  </code></pre>
  
  <p>This goes on like this with around 200 rows. Notice how the same ID appears many times but with a different task number. I would like to add all of these scores together for each ID and then take the total value for each ID and output the top 10. I'm looking for a SQL-command to do this, ofcourse i could do this by reading the tables and calculate it in the Python language. But that is not the way i wan't to do it by.</p>
  
  <p>Is this possible, if so how?</p>