SQL Window Functions Moving Average

AArete's client analytics reporting workflow needs a smoother view of daily revenue from active client accounts. Write a PostgreSQL query that aggregates eligible transactions and calculates a rolling three-day average.

Requirements

1. Join revenue_transactions to client_accounts and include only accounts with account_status = 'active'.
2. Calculate daily_revenue, the total revenue for each transaction date.
3. Calculate moving_avg_3_days: the average of the current date's revenue and the two preceding dates that have revenue (reporting dates, not calendar days). If fewer than three dates exist, average the available rows.
4. Round moving_avg_3_days to two decimal places with ROUND(..., 2). Leave daily_revenue as the plain sum (amounts already have two decimals).
5. Return revenue_date, daily_revenue, and moving_avg_3_days in ascending date order.