[Growth rate using SQL in BigQuery - Part 1] Computing a month over month revenue growth rate #SQL #BigQuery

growth_rate_1.sql

SELECT
  DATE_TRUNC(PARSE_DATE('%Y%m%d',
      date),MONTH) AS months,
  ROUND(SUM(totals.totalTransactionRevenue)/10e+6,2) AS revenue,
FROM
  `bigquery-public-data.google_analytics_sample.ga_sessions_20*`
GROUP BY
  1
ORDER BY 
  1