Given a table of inventory transactions, write a query to calculate the rolling 7-day average of raw material consumption at ATC Manufacturing.