7-Day Rolling Average Excluding Weekends

We have a table of daily sales data. Write a query to calculate the 7-day rolling average revenue for each product, but exclude weekends from the calculation and handle gaps in the data.

Use a seven-calendar-day window ending on each recorded sale date. Missing dates must not be treated as zero, and multiple records for the same product and date should contribute to that day's revenue.

Output

1. One row per product and recorded weekday with sales data
2. Columns: product_id, product_name, sale_date, daily_revenue, and rolling_7_day_avg
3. Exclude weekend dates, round the rolling average to two decimal places, and order by product_id, then sale_date