Complex~33min

The Demand Forecast That's Always Wrong the Same Way

The North region's 7pm forecast error has grown every month for 6 months — 50, 80, 120, 170, 230, 300 MW — a systematic and worsening under-prediction with no documented cause. The noon hour also shows a steadily growing error, but that one has a known_factors record explaining it: a new solar farm coming online, already factored into revised planning.

Tables you'll query

demand_forecastsknown_factors

What you'll learn

CTEs (WITH clause)Window FunctionsDate & Time Functions
Investigate this case →