Quiet Failures
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
- mid
Interview Prompt
A payments platform's release team is auditing how reliably each service ships to production, where the deploy log records that environment inconsistently as both 'Production' and 'production'. For each service with at least three production deployments, report its total deployments, how many carried a 'success' status, and the resulting success rate, least reliable first.
Summary
Some services land every release; others only look like they do. Find the ones production can't count on.
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