5 SQL window-function traps that show up in data engineering interviews (with runnable DuckDB examples)

Default frames, ties, LAST_VALUE, filters before windows and sparse moving averages. Five small traps that separate knows SQL from writes correct pipelines.