Repos with More Builds Than Commits
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
Only a passing build counts toward CI coverage, and a commit that adds more than 350 lines is a major change. The release team wants the repos whose successful builds at least match their major commits, with each repo's successful build count.
Summary
More builds than commits. Something is off.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision