Forward-Fill Missing Values

hard
Unit 24 · Window Functions & Cohorts0/0 to milestone

Some order totals failed to load and are NULL. For reporting, carry the last known total forward in date order (ties by id). Return id, order_date and filled_total, sorted by order_date, then id. Rows before the first known value stay NULL.

Pro problem

Unlock this and every premium problem across all tracks — plus hidden-test grading, advanced AI engineering modules and new content every week.

Start 7-day free trial
query.sql · SQLite
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Forward-Fill Missing Values · TechGradify