title: SUM of grouped COUNT in SQL Query
body: <p>I have a table with 2 fields:</p>
  
  <pre>
  ID  Name
  --  -------
  1   Alpha
  2   Beta
  3   Beta
  4   Beta
  5   Charlie
  6   Charlie
  </pre>
  
  <p>I want to group them by name, with 'count', and a row 'SUM'</p>
  
  <pre>
  Name     Count
  -------  -----
  Alpha     1
  Beta      3
  Charlie   2
  <b>SUM       6</b>
  </pre>
  
  <p>How would I write a query to add SUM row below the table?
  </p>