How would you use SQL window functions to compute a rolling 7-day metric for clinical events at Bioscope.Ai?