Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling Cohort Engagement with SQL

Medium
MediumSQL & Data ManipulationWindow FunctionsCohort AnalysisRunning TotalsAsked 1 times

Problem

How would you use SQL window functions to compute rolling 7-day engagement metrics by user cohort?

Practicing as: Data Scientist interview at Virtual Vocations

Hi, I'll play your Virtual Vocations interviewer for the Data Scientist role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.

Take this as a live interview session →

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Virtual Vocations Data Scientist Interview Questions
Next questions
SuperhumanRolling 7-Day Window by CohortMediumHudl7-Day Rolling Engagement With CohortsHardOscar InsuranceRolling Cohort Engagement with SQLMedium