[SQL] Selecting number of rows at a sample rate over a time range in big query

I have timestamp rows and I want to query over time interval [t1,t2] where t2-t1 can be few hours of span. I want to count the number of rows in this range but I want the output say where the rows are counted at 15 minutes interval. So if t2-t1 is 120 minutes, I expect 8 rows in output and the number of times rows occurred in the 15 minute windows.

Not very clear on how to do that with Range functions

Continue reading...