Loading problem...
00:00
8289. User Churn Risk Assessment
HardSQLITE886 / 1625
Business Problem
You are a Retention Data Scientist at Netflix. The executive team wants to proactively identify users at risk of churning. Build a churn risk assessment that combines three signals: subscription status, payment failures, and how recently the user watched content. Classify each user into one of four risk levels:
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to ProRelevant companies
Company names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Tags
#multi-cte#left-join#case-when#coalesce#julianday#classification#streaming
8289. User Churn Risk Assessment
Hard886 / 1625
Business Problem
You are a Retention Data Scientist at Netflix. The executive team wants to proactively identify users at risk of churning. Build a churn risk assessment that combines three signals: subscription status, payment failures, and how recently the user watched content. Classify each user into one of four risk levels:
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to ProRelevant companies
Company names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Tags
#multi-cte#left-join#case-when#coalesce#julianday#classification#streaming
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to Pro