title: How can I see point in time rolling five week counts of distinct values?
body: <p>I am trying to see the point in time rolling five week count of distinct employees paid.  For example, in week 48 I would need to see the count of distinct employees paid in weeks 44 through 48.  I think I have to include something like "WHERE Week_Number BETWEEN Week_Number -5 AND Week_Number" but am not sure how to make this work.  The output should just be the Year, Week Number, and count of distinct employee IDs.</p>
  
  <pre><code>SELECT Week_Number,
      Year, 
  Account, 
  count(distinct EmployeeID as 'EmployeeCount'
  FROM [Table]
  GROUP BY Week_Number, Year, Account
  </code></pre>