title: Is there a way to look at USER IDs that are the same, and then count entries within an hour of each other
body: <pre><code>   UserId             tx_date
  23   1250 2016-05-06 08:35:45
  36   1491 2015-06-27 03:34:45
  40   1491 2015-06-27 03:48:15
  44   1491 2017-05-05 03:52:47
  48   1491 2017-05-14 10:52:34
  52   1491 2017-05-15 06:01:12
  </code></pre>
  <p>Hi - So as the Title specifies, I'm trying to look at USERIDs that are the same, for example 1491 over the 5 entries, and count entries if the TX-date are within an hour of each other. I am really unsure how to tackle this.</p>
  <p>So what I am looking for is to find that 1491 in this example has 2 transactions within an hour of each other eg</p>
  <pre><code>03:52:47 - 03:48:15 &lt; 1 hour 
  03:48:15 - 03:34:45 &lt; 1 hour
  </code></pre>
  <p>Thanks in advance</p>