Interview Questions
Interview Guides
Experiences
Explore
Get started
Sign in
Interview Guides
Rolling 30-Day Active Users | Dataford Interview Questions
All questions
/
SQL & Data Manipulation
Asked 1mo ago
|
The Boston Consulting Group
Rolling 30-Day Active Users
Medium
Asked at 1 company
Window Functions
Date Functions
Running Totals
Problem
Write a SQL query to calculate the rolling 30-day active user count from a raw event log table.
Question
Answer
Problem
Write a SQL query to calculate the rolling 30-day active user count from a raw event log table.
Your answer
Edit
Preview
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
0 words
target ~200
Try a free preview
Stuck? Get a hint
Past attempts
Up next
7-Day Rolling Active Users
Medium
Top N Users by Activity
Medium
7-Day Rolling DAU on Facebook
Hard
Next question
