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
An engineering manager is auditing repositories that have gone quiet, where a repository's idleness is the average number of days between its consecutive commits. Commit timestamps are stored as text and the queries run on SQLite, so the day count has to come out of the stored timestamps. Surface the repositories whose average gap runs longer than 5 days, ordered from the most idle to the least, and number the standings as you go.
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