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