Given a table of shipment transactions, write a query using window functions to calculate the rolling 7-day average of delivery times.
