I have a table with data for each month end and want to know the LEAD and LAG data points either side of each month. For example:SELECT month_date,
LEAD(month_date) OVER (PARTITION BY id ORDER BY month_date) next_month_date,
LAG(month_date) OVER (PA...