For the 'US' region only, return each day's revenue and a 7-day moving average (the current day plus the 6 days immediately before it), rounded to 2 decimal places. Early days with fewer than 7 days of history should average over however many days actually exist so far.
Expected output
day
moving_avg_7d
2023-01-01
550
2023-01-02
780
2023-01-03
860
First 3 of 42 rows your query should return. Your column aliases don't need to match.