00:00
8048. Top Users by Longest Consecutive-Day Engagement Streak
ExpertSQLITE845 / 1625
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ 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
#islands-and-gaps#streak-detection#consecutive-days#row-number#date-arithmetic#union-three-tables#tie-breaking#meta-interview#engagement#advanced-window#interview-classic
8048. Top Users by Longest Consecutive-Day Engagement Streak
Expert845 / 1625
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ 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
#islands-and-gaps#streak-detection#consecutive-days#row-number#date-arithmetic#union-three-tables#tie-breaking#meta-interview#engagement#advanced-window#interview-classic
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to Pro