GCP查询-如何写年度差额？

SELECT
  EXTRACT(YEAR FROM date_column) AS year,
  SUM(revenue) AS total_revenue,
  LAG(SUM(revenue)) OVER (ORDER BY EXTRACT(YEAR FROM date_column)) AS previous_year_revenue,
  SUM(revenue) - LAG(SUM(revenue)) OVER (ORDER BY EXTRACT(YEAR FROM date_column)) AS yearly_difference
FROM
  your_table
GROUP BY
  year
ORDER BY
  year;