---
source: crates/fraiseql-core/tests/window_function_snapshots.rs
expression: "plan_and_generate(&query(), DatabaseType::SQLServer)"
---
SELECT occurred_at AS occurred_at, revenue AS revenue, LEAD(revenue, 1, 0) OVER (ORDER BY occurred_at ASC) AS next_revenue FROM tf_sales