What SQL query would you use to calculate a rolling 7-day average of patient encounters by hospital using window functions?
