What SQL window functions would you use to calculate a rolling average of transaction amounts over a 30-day period?
