Learn
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
Instructions
1.
Add a SELECT
statement to calculate the churn rate. The result should contain two columns:
month
- selected fromstatus_aggregate
churn_rate
- calculated fromstatus_aggregate.canceled
andstatus_aggregate.active
.
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.