Now comes the moment we’ve been waiting for - the actual churn rate.

We use the number of canceled and active subscriptions to calculate churn for each month: churn_rate = canceled / active



Add a SELECT statement to calculate the churn rate. The result should contain two columns:

  • month - selected from status_aggregate
  • churn_rate - calculated from status_aggregate.canceled and status_aggregate.active.

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?