Codeflix User Churn exercise Step 7 (status_aggregate)

Hey!
First time I ask about help regarding the exercises. So for some reason if I run the code, I don’t get query output. Can you spot the mistake in the syntax? (I know there are still some conditions wrong, but it should not prevent me to get an output, right?)

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 (segment = ‘87’)
AND (subscription_end > first_day
OR subscription_end IS NULL)
THEN 1
ELSE 0
END AS ‘is_active_87’,
CASE
WHEN (subscription_start < first_day)
AND (segment = ‘30’)
AND (subscription_end > first_day
OR subscription_end IS NULL)
THEN 1
ELSE 0
END AS ‘is_active_30’,
CASE
WHEN (segment = ‘87’)
AND (subscription_end BETWEEN first_day AND last_day)
THEN 1
ELSE 0
END AS ‘is_cancelled_87’,
CASE
WHEN (segment = ‘30’)
AND (subscription_end BETWEEN first_day AND last_day)
THEN 1
ELSE 0
END AS ‘is_cancelled_30’
FROM cross_join
),
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
)
SELECT * FROM status_aggregate
LIMIT 10
;

PS: I was to unpatient to wait for the code generated as a link, so that’s why you get to look at it this way.