SQL
Given a list of (date, duration) tuples, how would you filter by time period and calculate summary stats (average, rolling sum)?
Data Scientist
Shopify
Onfido
Coupang
Salesforce
Fitbit
SoFi
Try Free AI Interview
Interview question asked to Data Scientists interviewing at Fitbit, Epic Games, Salesforce and others: Given a list of (date, duration) tuples, how would you filter by time period and calculate summary stats (average, rolling sum)?.