title: Count(*) and Sum in the same row
body: <p>I'm banging my head against the wall, here. I've looked at dozens of StackOverflow questions that are similar, and they get me close, but I haven't found one yet that does what I need.
  I have thousands of questions in a database with answers from multiple users to each question. I need to aggregate the answers to show the count of distinct answers per question. That's the easy part; where I'm stumbling is in adding a Sum column to show the total number of answers given for each question. I can do it if I restrict the Where clause to specific questions, but I'm trying to get this all into one query if possible.
  Here's the Query:</p>
  
  <pre><code>select c.ID, a.userID. c.question, a.answer, count(a.answer) as cnt
  from NotableAnswers a, categories b, questions c
  where c.fkCategory = b.ID and a.questionID = c.ID and b.ID = 18
  Group By a.answer, c.ID, c.question
  Order By c.ID, answer asc
  </code></pre>
  
  <p>What I need is a result set that looks like this</p>
  
  <pre><code>ID   | userID |  Question   |    Answer    |   cnt   |    totcnt
  ------------------------------------------------------------------
  175  | 10318  |Favorite...  |Dropbox       |    15   |      35
  175  | 10354  |Favorite...  |Box           |    2    |      35
  175  | 10323  |Favorite...  |Google Drive  |    15   |      35
  175  | 103111 |Favorite...  |Cubby         |    3    |      35
  186  | 10318  |Best IDE...  |IntelliJ      |    4    |      12
  186  | 103613 |Best IDE...  |Android Studio|    6    |      12
  186  | 103117 |Best IDE...  |Eclipse       |    2    |      12
  </code></pre>
  
  <p>This set shows the Answer as an aggregate and the count of that specific answer along with the sum of the number of answers provided to each distinct question.</p>
  
  <p>Any and all help greatly appreciated.</p>