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

Window functions are the most common SQL topic in data engineering interviews, and most candidates know the syntax. The follow-up questions are where people stumble. Here are five traps, each with a t