title: LINQ: Selecting items from a list (Group By/Select/Sum & Max!)
body: <p>Just getting my head around Linq and having lots of fun! Can any one aid me with a query for this:<br>
  I have a list of data:<pre>
      Key  Value
      Aaa  12
      AaA  10
      AAa  5
      BBB  2
      Bbb  1
  </pre>
  1. I want to group by Key.ToUpper()<br/>
  2. For every group I need the Max(Value) &amp; Sum(Value)<br/>
  3. For every group I want to select the entries 
  There the <strong>Value != Max(value)</strong> <br>
  the final result should be like this:<pre>
      Key Max Total
      AaA 12  27
      AAa 12  27
      Bbb 2   3</pre>
  Thanks!</p>
  
  <p>Update, actually I also need the Key from the Maximum entry:<pre>
      Key Max Total Correct
      AaA 12  27    Aaa
      AAa 12  27    Aaa
      Bbb 2   3     BBB </pre></p>