Early Commit Velocity by Author
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
- L6
Interview Prompt
Engineering management is studying contributor patterns during the first year of every repo's life on CI. The clock starts at a repo's very first CI build and runs for one year. For each author who committed inside that window, report the typical size of their commits (average lines added) and how long after the first build their commits typically landed.
Summary
How productive was each author during the first year of a repo's CI pipeline
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