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
- Seniority
- L5
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.
Summary
Some repos go quiet for too long.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision