SQL
Given a list of (date, duration) tuples, how would you filter by time period and calculate summary stats (average, rolling sum)?
Was asked at
Practice this question with AI
Go Premium
More interviews, more skills, more success.
Practice More Questions
No answers yet
Be the first to share your approach to this question
Turn Adequate Answers Into Great Ones
See exactly what separates candidates who get offers
The Difference That Matters
Adequate
Gets you noticed
Great
Gets you hired
Real interview cases with side-by-side analysis
Battle-tested frameworks for every interview scenario
Learn what makes answers adequate vs great
Real case breakdowns with expert commentary
Advanced storytelling and delivery techniques
Interview question asked to Data Scientists interviewing at StubHub, GoCardless, Blend and others: Given a list of (date, duration) tuples, how would you filter by time period and calculate summary stats (average, rolling sum)?.