title: Using LINQ to count value frequency
body: <p>I have a table</p>
  
  <pre><code>ID|VALUE
  </code></pre>
  
  <p>VALUE is an integer field with possible values between 0 and 4. How can I query the count of each value?</p>
  
  <p>Ideally the result should be an array with 6 elements, one for the count of each value and the last one is the total number of rows.</p>