Hi everyone! Here is my Codeflix SQL project. Any feedback appreciated. Thanks!
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