Top 50 Lag/Lead Interview Questions
The most frequently asked Lag/Lead questions across all roles and companies, ranked by real interview frequency. Updated daily.
Aggregate user activity by week, then use LAG to compare sessions and watch time versus the prior active week.
B Lab Global
Tapad
ScaleCompute each user's seven-day activity average and compare it with the corresponding rolling average from the prior week.
FactoredRRackspace TechnologyGG-PCalculate three-row moving averages with SQL window frames after aggregating order data by seller and date.
ShopeeUse LAG to compare an operational KPI week over week and surface absolute and percentage change.
GIC
Uber Freight
CorsairCalculate monthly cohort retention using date-based cohorts, aggregation, and window functions.
XtageBBoston Tech IndiaKKhan Cloud SolutionsUse PostgreSQL window functions to compare Harnham Recruiter Cloud's seven-day application average with the prior week.
Harnham
StepStone Group
HachSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Aggregate user engagement by feature and date, then compare daily activity with the previous available date.
Join BetMGM incident, workflow, and KPI data to rank the highest-impact operational bottlenecks by month.