title: Using Gaps and Islands to Find Consecutive Hours/Dates- SQL/BigQuery
body: <p>I have a table in BigQuery that looks like this:</p>
  
  <pre><code>Caller_Number | month  |  day| call_time
  --------------|--------|-----|----------
  1             |  5     |  15 | 12:56:17
  </code></pre>
  
  <p>I want to write a SQL query for BigQuery that will allow me to count the consecutive hours in which at least one call was made (sorted by caller_number), and the consecutive days in which at least 10 consecutive hours with calls occurred (sorter by caller_number). I have been looking at the existing resources on gaps and islands, but can't seem to figure out how to apply it to consecutive dates and hours.</p>