7-Day vs 28-Day Rolling Avg Divergence

Problem

**[Classic — forecasting]**

Compare a short-window vs long-window trend by computing both the 7-day and
28-day rolling averages, and the **divergence** (7d - 28d).

A positive divergence often signals an accelerating trend.

Return the latest 3 dates with `metric_date`, `avg_7d`, `avg_28d`, `divergence`
(all rounded to 2 dp), ordered by date descending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns metric_date, avg_7d, avg_28d, divergence.

Starter code (SQL)

SELECT *
FROM daily_metrics;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium
• Agents With a Dominant Contact ChannelMedium