title: How to query for rows that have highest column value among rows that have same value for one of the columns
body: <p>I have UserScores Table with data like this:</p>
  
  <pre><code>Id    userId   Score
  1       1       10
  2       2       5
  3       1       5
  </code></pre>
  
  <p>I would like to have a query or SQL block that can give me the following output</p>
  
  <pre><code>Id    userId   Score
  3       1       5
  2       2       5
  </code></pre>
  
  <p>That is, I would like to pick rows that are unique by 'user id' that belonging to the highest 'id' column value.</p>