Calculating Churn Rates - Query doesn't run

[lisalisaj]

@bit1400757621

status_aggregate AS(
SELECT
SUM(is_active_87) AS “sum_active_87”,
SUM(is_active_30) AS “sum_active_30”,
SUM(is_canceled_87) AS “sum_canceled_87”,
SUM(is_canceled_30) AS “sum_canceled_30”
FROM status
GROUP BY month

This also needs to be tweaked. You need to add something to the SELECT statement before you SUM .

[bit1400757621]

Do you mean I miss the parent " FROM cross_join " ?

[lisalisaj]

You need to add ‘month’ to your statement above:

status_aggregate AS
	(SELECT month, SUM(is_active_87) as 'sum_active_87', SUM(is_active_30) as 'sum_active_30', SUM(is_canceled_87) as 'sum_canceled_87', SUM(is_canceled_30) as 'sum_canceled_30'
 FROM status
 GROUP BY month  
 		)

[lisalisaj]

ie:
…
(AND segment = 30)

[bit1400757621]

Thank you. I test my code one by one and solve it.

[lisalisaj]

Excellent! 🎉You’re welcome.