Loading interview...

Commit Cadence

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

Domain
SQL
Difficulty
hard

Interview Prompt

The engineering manager wants to flag repos with infrequent commit activity. For each repository, compute the average gap in days between consecutive commits. Only include repos whose average gap exceeds 5 days, and rank them by how inactive they are, widest average gap first. Return the repo name, average gap, and inactivity rank.

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