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.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
Meta
Spotify
Meta ITDemonstrate window functions by ranking active employees by salary within each department.
Johnson & Johnson
AvidXchange
CRIFCalculate each user's running order total over time using a window function.
Bayer
Sparksoft
Western DigitalCompute each user's seven-day activity average and compare it with the corresponding rolling average from the prior week.
FactoredRRackspace TechnologyGG-PCalculate patient rolling 7-day averages and rank patients within each Medpace research site using layered window functions.
Medpace
Charles Schwab
Stanford School of MedicineAggregate posted Arcesium portfolio sales by date, then calculate each active portfolio's cumulative sales with a window function.
Providence
Avenue Code
Del Rey Systems & TechnologyUse PostgreSQL window functions to calculate user running spend and rank users by total spend within each signup cohort.
NewMarket
Deloitte
AllstateCalculate each user's 7-day rolling transaction average and daily spend rank using PostgreSQL window functions.
RakutenSign up to see every question
Create a free account to unlock this list and practice real interview questions.