FAQ: Calculating Churn - Single Month II

Would anybody happen to know where I went wrong? I used the video as a guide, but for some reason the same code doesn’t come back with any results:

WITH months AS
(
SELECT
‘2017-01-01’ AS first_day,
‘2017-01-31’ AS last_day
UNION
SELECT
‘2017-02-01’ AS first_day,
‘2017-02-28’ AS last_day
UNION
SELECT
‘2017-03-01’ AS first_day,
‘2017-03-31’ AS last_day
),cross_join AS
(SELECT * FROM subscriptions
CROSS JOIN months),
status as
(SELECT id, first_day AS month,
) ( CASE
WHEN (subscription_start<first_day) AND (subscription_end>first_day OR subscription_end IS NULL) AND (segment = 87) THEN 1
ELSE 0
END as is_active_87,
) CASE
WHEN (subscription_start<first_day) AND (subscription_end>first_day OR subscription_end IS NULL) AND (segment = 30) THEN 1
ELSE 0
END as is_active_30
CASE
WHEN (subscription_end BETWEEN first_day AND last_day) AND (segment = 87) THEN 1
ELSE 0
END AS is_canceled_87
CASE
WHEN (subscription_end BETWEEN first_day AND last_day) AND (segment = 30) THEN 1
ELSE 0
END AS is_canceled_30
) SELECT * FROM subscriptions;