Top 50

Topic

~9h total · Updated weekly · Last refresh Jul 24

Top 50 Lag/Lead Interview Questions

The most frequently asked Lag/Lead questions across all roles and companies, ranked by real interview frequency. Updated weekly.

Measure Week-Over-Week Metric Changes

Medium

Use LAG to compare an operational KPI week over week and surface absolute and percentage change.

Uber Freight

GIC

Eaze

Compare Current vs Historical Customer Behavior

Hard

Use window functions and CTEs to compare each customer’s latest month against their prior 3-month behavior baseline.

Applied Systems

Quantium

BASF

User Ride Trends with Windows

Medium

Use monthly aggregation and LAG to measure each rider’s completed ride trend and month-over-month change.

Didi Chuxing

Uber

Detect Sudden Reviewer Accuracy Drops

Hard

Use window functions to flag a sudden drop in reviewer accuracy across consecutive review days.

OpenAI

Build Driver Workflow Event Sequences

Hard

Use ROW_NUMBER, LAG, and LEAD to build per-driver Motive Driver App event sequences with previous/next events and time gaps.

Motive

Track Monthly Customer Activity Changes

Hard

Use window functions to compare each customer's monthly activity against prior months and identify behavior changes.

Qantas

More SQL & Data Manipulation questions with a free account

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

Open any question for its full solution and discussion.