Dataford
Top 50
Topic roadmap
Updated weekly · Last refresh Sep 13

Top 50 Running Totals Interview Questions

The most frequently asked Running Totals questions across all roles and companies, ranked by real interview frequency. Updated daily.

50questions
~17htotal time
408companies covered
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
Window FunctionsStart here. 46 questions · ~920 min
7-Day Rolling Active UsersMedium
Practice
Recently asked

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
Running Total With Window FunctionsEasy
Practice
Recently asked

Calculate each user's running order total over time using a window function.

Window FunctionsDate FunctionsRunning TotalsSparksoftBayerWestern Digital
Running Total Sales by DateMedium
Practice
Recently asked

Aggregate posted Arcesium portfolio sales by date, then calculate each active portfolio's cumulative sales with a window function.

Window FunctionsRunning TotalsProvidenceAvenue CodeDel Rey Systems & Technology
Rolling 7-Day Average with Window FunctionsMedium
Practice
Recently asked

Calculate patient rolling 7-day averages and rank patients within each Medpace research site using layered window functions.

Window FunctionsRankingRunning TotalsMedpaceCharles SchwabHealth Care Solutions At Home
Window Functions for Running TotalsMedium
Practice

Use PostgreSQL window functions to calculate user running spend and rank users by total spend within each signup cohort.

Window FunctionsRankingRunning TotalsNewMarketDeloitteAllstate
Customer Transaction Running TotalsEasy
Practice
Recently asked

Calculate each customer's cumulative transaction amount over time using a CTE and window function.

Window FunctionsDate FunctionsRunning TotalsBanco SantanderAnzBank Of Tokyo-Mitsubishi UFJ
Rolling 7-Day Transaction AverageMedium
Practice

Calculate each customer's 7-day transaction average using daily aggregation and a PostgreSQL window frame.

Window FunctionstransactionsRunning TotalsTruistBBVAQuantexa
SQL Rolling Average and RankingHard
Practice

Use CTEs and window functions to calculate 7-day transaction averages and rank Loft users within each region.

Window FunctionsRankingRunning TotalsLoftArcadisCgi Nederland
More Window Functions questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
2
More topics4 questions · ~80 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.