overlapping windows (as written)
first-touch dedup (ROW_NUMBER)
Filters compile into extra predicates on the ON clauses of LEFT JOINs (preserving outer-join semantics) and into WHERE for inner joins. Toggle canonical / compiled on any query to see the generated SQL.
R run · 1–6 switch · E export active · P PDF