Write a complex SQL query using window functions to compute a rolling average over a dynamic time window.
