stripe_analysis_4.sql

news as (

  select date_month, sum(total) as value
  from data
  where revenue_category = 'new'
  group by 1

), renewals as (

  select date_month, sum(renewal_component_of_change) as value
  from data
  where revenue_category in ('renewal', 'downgrade', 'upgrade')
  group by 1

), prepaids as (

  select date_month, sum(total) as value
  from data
  where revenue_category = 'prepaid renewal'
  group by 1

), churns as (

  select date_month, sum(total) as value
  from data
  where revenue_category = 'churn'
  group by 1

), upgrades as (

  select date_month, sum(change) as value
  from data
  where revenue_category = 'upgrade'
  group by 1

), downgrades as (

  select date_month, sum(change) as value
  from data
  where revenue_category = 'downgrade'
  group by 1

)