BigQuery uses the same LAG/LEAD syntax. The main difference: `DATE_TRUNC(event_date, MONTH)` instead of `DATE_TRUNC('month', event_date)`, and `DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)` instead of `CURRENT_DATE - INTERVAL '1 month'`.