title: Finding when a rolling group of day's values exceed a threshold
body: <p>I am looking to create a flag for when 3 consecutive days (looking backwards) exceed a value (let's say 5).</p>
  <pre><code>date   value active_flag
  202101 1     0
  202102 2     0
  202103 1     0
  202104 6     0
  202105 9     0
  202106 7     1
  202107 1     0
  202108 4     0
  </code></pre>
  <p>Apologies for lack of code as I am relatively new to SQL so am not sure of how to show this in a window function but I was thinking of counting number of days exceeding value = 3 to return this flag</p>