I have a table in BigQuery that looks like this:
Caller_Number | month | day| call_time
--------------|--------|-----|----------
1 | 5 | 15 | 12:56:17
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.