Build Health
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
- L4
Interview Prompt
The platform team wants a CI health leaderboard for the all-hands. Rank repositories in `ci_builds` by success rate, where rate is measured against every build the repo ran (not just builds that resolved to success or failed). Ignore repos that haven't built enough to be meaningful.
Summary
Rank every repo by how often CI stays green.
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