Loading interview...

Average Fulfillment Lag

A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
medium
Seniority
mid

Interview Prompt

The operations team is measuring fulfillment lag across the customer base. For each user, compute the average number of days between their transaction dates and today, only considering transactions with a positive amount. Present users from the longest average lag to the shortest.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision