Top 50
Topic roadmap
Updated weekly · Last refresh Nov 1

Top 50 calculations Interview Questions

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

50questions
~17htotal time
56companies covered
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 48 questions · ~970 min
Rolling Averages with SQL Window FunctionsMedium
Practice
Recently asked

Calculate three-record rolling account balance averages using PostgreSQL window functions.

Window Functionsfinancial datacalculationsAAppstrailBBrukerLLegal & General
Moving Average Delivery TimesMedium
Practice

Calculate daily delivery averages and a trailing seven-day moving average using PostgreSQL window functions.

Window FunctionsDate FunctionscalculationsFFedEx ExpressGopuffZomato
SQL Metrics with JoinsMedium
Practice
Recently asked

Compute joined metrics across multiple tables with filters and aggregations.

JoinscalculationssqlNNewfold DigitalRelativityWaymo
Rolling 7-Day Production AverageMedium
Practice
Recently asked

Calculate daily production and its rolling seven-day average, including zero-output calendar dates.

Window FunctionsDate FunctionscalculationsNevada Staffingoonsemi
SQL 7-Day Rolling ImpressionsMedium
Practice

Calculate daily impressions per active user and its 7-day rolling average using PostgreSQL aggregations and date-based windows.

Window FunctionsDate FunctionscalculationsActivisionSamsung Ads
Calculate churn rate from a subscription tableMedium
Practice

Calculate monthly churn as companies terminated during the month divided by companies active at the month's start.

Date FunctionscalculationsAggregationsIntuit
Rolling 30-Day Average Equipment UsageMedium
Practice
Recently asked

Calculate daily equipment usage and its 30-day rolling average while handling multiple readings and NULL values.

Date FunctionsData AnalysiscalculationsMicron TechnologyEEcolab
Month-over-Month Sales ComparisonMedium
Practice

Compare the latest available month's sales with the preceding month's sales using PostgreSQL date aggregation.

Window FunctionsLag/LeadDate FunctionsLG Electronics North AmericaRevature
More SQL & Data Manipulation 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 topics2 questions · ~40 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.