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

Did you come across this question in an interview?

Your answer

Try Free AI Interview

Google logo

Google

Product Manager

Prepare for success with realistic, role-specific interview simulations.

Product Strategy
Meta logo

Meta

Product Manager

Prepare for success with realistic, role-specific interview simulations.

Product Sense
Meta logo

Meta

Engineering Manager

Prepare for success with realistic, role-specific interview simulations.

System Design
Amazon logo

Amazon

Data Scientist

Prepare for success with realistic, role-specific interview simulations.

Behavioral
  • Given a list of (date, duration) tuples, how would you filter by time period and calculate summary stats (average, rolling sum)?
  • Suppose we have a dataset of (date, duration) tuples. How would you filter by a specific time period and then generate summary statistics, including the average duration and rolling sum, for each date within that time period?
  • How would you approach the task of filtering by time period and calculating summary statistics (average, rolling sum) from a dataset of (date, duration) tuples?
  • Given a set of (date, duration) tuples, how would you filter by a specific date range and then compute the average duration and rolling sum for each date within that range?
  • Suppose we have a dataset of (date, duration) tuples. Explain how you would filter by a particular time period and analyze the data to produce summary statistics such as the average duration and rolling sum?
  • Can you walk me through how you would filter data by time period in a set of (date, duration) tuples and compute some summary statistics such as the average duration and rolling sum?
  • Let's imagine we have a list of (date, duration) tuples. How would you filter by a specific time frame and then calculate summary stats like the average duration and rolling sum?
  • Given a list of (date, duration) tuples, what is your process for filtering by time period and then calculating summary statistics such as the average duration and rolling sum?
  • How would you extract and compute summary statistics such as the average duration and rolling sum from a set of (date, duration) tuples that have been filtered by a particular time period?
  • Given a dataset of (date, duration) tuples, can you demonstrate how you would filter the data within a specific time frame and calculate the average duration and rolling sum for each date within that time frame?

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)?.