title: Translate SQL to lambda LINQ with GroupBy and Average
body: <p>I spend a few hours trying to translate simple SQL to lambda LINQ</p>
  
  <pre><code>SELECT ID, AVG(Score) FROM myTable
  GROUP BY ID
  </code></pre>
  
  <p>Any idea?</p>