title: SQL Server query for count per hour
body: <p>Using SQL Server 2014 - I am struggling with a query that would search/filter with 2 criteria (one of them is per hour). I have found various solutions that work separately but I have dificulties in joining them together as one.</p>
  
  <p>I have </p>
  
  <pre><code>UserID, event1, timestamp  
  </code></pre>
  
  <p>I would like to select: if the UserID has records 10 or more times in event1 column per hour for each hour (24hrs)</p>