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.
FactoredCContentsquareCCult (Cure.fit)Use LAG to compare an operational KPI week over week and surface absolute and percentage change.
GIC
Uber Freight
CorsairUse window functions and CTEs to compare each customer’s latest month against their prior 3-month behavior baseline.
Applied Systems
Quantium
BASFUse PostgreSQL window functions to compare Harnham Recruiter Cloud's seven-day application average with the prior week.
Harnham
HachIInternshalaUse monthly aggregation and LAG to measure each rider’s completed ride trend and month-over-month change.
Didi Chuxing
UberUse CTEs and LAG to calculate monthly average cardholder transaction volume and month-over-month percentage change.
Capital One
Notion LabsCompare each product's current and previous month revenue, including absolute and percentage changes.
Google
Keyrus FranceSign up to see every question
Create a free account to unlock this list and practice real interview questions.