Analyze Data with SQL - Codeflix User Churn Project

Hi everyone! Here is my Codeflix SQL project. Any feedback appreciated. Thanks!

1 Like

Good work! It’s very clear your presentation.
Just on slide 9 you’ve used this code:

CASE 
 WHEN (subscription_start < first_day) AND (subscription_end > first_day OR subscription_end IS    NULL) THEN 1
ELSE 0
 END AS is_active,

And I think that you need to use the sign >= on subscription_end >= first_day