Write a SQL query using window functions to calculate each patient's 7-day rolling average lab value and compare it to their prior week.
