Three-Day Rolling Average of Solar Output

Problem

Table: `panel_output`

| Column Name | Type |
|---|---|
| panel_id | int |
| kwh | int |
| output_date | date |

Each row is the energy a solar panel produced on one day. A panel records at most one row per day.

For each panel, compute the rolling average of `kwh` over the current day and the two days before it, **rounded to 2 decimals**. Only output a value when all three days are consecutive calendar days (no gap). Return `panel_id`, `output_date`, and the average aliased as `avg_3day`. Order by `panel_id`, then `output_date`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns panel_id, output_date, avg_3day.

Starter code (SQL)

SELECT *
FROM panel_output;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium