title: Select Count Distinct
body: <p>I would like to count the number of installations of each Member in a table similar to this. But this count distinct drives me nuts...</p>
  
  <pre><code>MemberID | InstallDate
  
  1 | Yesterday
  
  2 | Today
  
  1 | Today
  
  3 | Today
  </code></pre>
  
  <p>The above table should produce something like this one..</p>
  
  <pre><code>MemberID | CountNumberOfInstallations
  
  1 | 2
  
  2 | 1
  
  3 | 1
  </code></pre>
  
  <p>p.s. I know it sound's like homework, but it isnt.</p>