SELECT DaysSinceEpoch,
  Distance,
  LAG(Distance, 5, 10) OVER (
    ORDER BY DaysSinceEpoch
  ) AS previous_day_sales,
  Distance - LAG(Distance, 5, 10) OVER (
    ORDER BY DaysSinceEpoch
  ) AS difference
FROM airlineStats;

WITH tmp AS (
  select count(*) as num_trips,
    DaysSinceEpoch
  from airlineStats
  GROUP BY DaysSinceEpoch
)

SELECT DaysSinceEpoch,
  num_trips,
  LAG(num_trips, 2) OVER (
    ORDER BY DaysSinceEpoch
  ) AS previous_num_trips,
  num_trips - LAG(num_trips, 2) OVER (
    ORDER BY DaysSinceEpoch
  ) AS difference
FROM tmp;