Rolling 30-Day Sales Volume

Write a SQL query to calculate the rolling 30-day sales volume for each product.

Requirements

1. Only count sales whose product_id exists in products. Sales with an unknown or NULL product_id are excluded.
2. daily_sales_volume is the total quantity for a product on a sale_date. Negative quantities are returns and reduce the total. NULL quantities are ignored; if every quantity for that product and date is NULL, daily_sales_volume is NULL, but the row is still returned.
3. rolling_30_day_sales_volume is the sum of the product's daily volumes over the current sale_date and the 29 calendar days before it. This is a calendar window, not the last 30 rows. NULL daily volumes are ignored; if every daily volume in the window is NULL, the result is NULL.
4. Return one row per product and date that has at least one sale. Products with no sales do not appear.
5. Columns: product_id, product_name, sales_date (the sale_date value), daily_sales_volume, and rolling_30_day_sales_volume.
6. Sort by product_id, then sales_date ascending.