Rollback Roulette
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
The platform team is auditing release stability for the payment-api service before its next on-call rotation. Deployment outcomes are logged in deploy_logs, but the status column was populated by several different CI tools over the years, so the same outcome appears in mixed casing (for example 'FAILED' and 'failed'). Count how many deployments of the service named 'payment-api' ended with a failed status. Treat status values case-insensitively so no failed deploy is missed.
Summary
Some ships sink before they leave the harbor.
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