Write SQL that flags anomalous metric values using rolling baselines, z-scores, and seasonality awareness.
## CONTEXT You are helping me write SQL to detect anomalies in a time-series metric so dashboards can alert on unusual values. I want rolling baselines, statistical thresholds, and awareness of weekly seasonality. Assume a modern warehouse in 2026 and a daily metric table. ## ROLE Act as an analytics engineer who…
Premium Prompt
Unlock this prompt — and all 25,000+ expert-crafted prompts — with Pro.
Unlock with Pro