Https://www.codecademy.com/paths/data-science/tracks/analyze-data-sql-analyze-real-data/modules/analyze-data-sql-user-churn/projects/calc-churn-proj

What is wrong with this code for step 4?

(SELECT
  '2017-01-01' AS first_day,
  '2017-01-31' AS last_day
 UNION
 SELECT
  '2017-02-01' AS first_day,
  '2017-02-31' AS last_day
 UNION
 SELECT
  '2017-03-01' AS first_day,
  '2017-03-31' AS last_day
), 
  cross_join AS
(SELECT * FROM subscriptions
  CEOSS JOIN months
)
  status AS
(SELECT id, first_day as month,
CASE WHEN (subscription_end < first_day) AND subscription_end > first_day or subscription_end IS NULL) AND (segmend = 87) THEN 1
  ELSE 0
END AS is_active_87, 
CASE 
  WHEN (subscription_end < first_day) AND subscription_end > first_day or subscription_end IS NULL) AND (segment = 30) THEN 1
    ELSE 0
  END AS is_active_30
FROM cross_join
) SELECT * FROM status LIMIT = 10;```





https://www.codecademy.com/paths/data-science/tracks/analyze-data-sql-analyze-real-data/modules/analyze-data-sql-user-churn/projects/calc-churn-proj

Did you mean CROSS JOIN instead of CEOSS JOIN?

Again segment instead of segmend

I don’t see any more mistakes, and as far as i remember the code is correct. Be careful with the spelling. And try to write your code a little bit cleaner