Successful Build Duration by Repository
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
The platform team is auditing CI spend by repository. For each repository, total the time its successful builds spent running during January 2026, reported in seconds, and keep every repository in the result even if it ran no successful builds that month.
Summary
CI throughput, repo by repo.
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