---
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, LAG(revenue, 1, 0) OVER (PARTITION BY data->>'category' ORDER BY occurred_at ASC) AS prev_revenue FROM tf_sales