Rolling period calculation in BigQuery

How to compute a rolling period calculation in BigQuery? In one of my previous posts, I've showcased using RANGE inside window function declarations in the context of computing a cumulative sum. Today we're going to look at another example often foun...