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
SELECT statement to calculate the churn rate. The result should contain two columns:
month- selected from
churn_rate- calculated from